29
Schema Manager Messages

VAS-01000 to VAS-04999: Schema Management Messages

VAS-01000: The Name field must contain a valid Oracle identifier.

Cause: The text you entered in the Name field is not a valid Oracle identifier.

Action: Make sure the entered value conforms to the guidelines for Oracle identifiers in Oracle7 Server SQL Reference.

VAS-01002: Hash column not defined.

Cause: The hash column has not been defined.

Action: Define a hash function.

VAS-01003: Long and Long Raw datatypes not allowed.

Cause: Long and Long Raw data types are not allowed for cluster columns.

Action: Use some other data type.

VAS-01004: The Size field must contain a numeric value.

Cause: A non-numeric value has been entered in the Size field.

Action: Enter a numeric value in the Size field.

VAS-01005: The Hash Keys field must contain a numeric value.

Cause: A non-numeric value has been entered in the Hash Keys field.

Action: Enter a numeric value in the Hash Keys field.

VAS-01006: A hash key value must be specified in the Hash Keys field.

Cause: The Hash Keys field is blank.

Action: Enter a numeric hash key value in the Hash Keys field.

VAS-01007: A Cluster needs at least one column.

Cause: The user tried to create a cluster without any columns.

Action: Specify a column name and type for the cluster.

VAS-01008: You must specify size(length) for a RAW column.

Cause: User tries to create raw datatype column without any size.

Action: Specify the raw size(length).

VAS-01200: The Database Link field must contain a valid Oracle identifier.

Cause: The value entered in the Database Link field does not conform to SQL guidelines.

Action: Check to make sure the value entered conforms to the guidelines for Oracle identifiers as explained in Oracle7 Server SQL Language Reference.

VAS-01203: The database link is not active.

Cause: The database link is not active.

Action: Make sure that the username/password and the service name is correct, and that the connection to the remote database is up.

VAS-01602: The Degree Value field must contain a numeric value.

Cause: A non-numeric value has been entered in the Degree Value field.

Action: Enter a numeric value in the Degree Value field.

VAS-01603: The Instance Value field must contain a numeric value.

Cause: A non-numeric value has been entered in the Instance Value field.

Action: Enter a numeric value in the Instance Value field.

VAS-01604: A value for the Degree field must be specified.

Cause: A value has not been specified in the Degree field.

Action: Specify a value for the Degree field.

VAS-01605: A value for the Instance field must be specified.

Cause: A value has not been specified in the Instance field.

Action: Specify a value for Instance field.

VAS-01606: Columns must be specified for the Index.

Cause: Columns have not been specified in the Index field.

Action: Specify the index columns.

VAS-01802: Unable to recompile object.

Cause: Could not compile the PL/SQL object. The PL/SQL object might be locked.

Action: Try again after some time.

VAS-01803: Unable to obtain PL/SQL source for object.

Cause: Could not get source for the PL/SQL object.

Action: Contact Worldwide Customer Support.

VAS-01804: PL/SQL source for object is too large. Truncating displayed source.

Cause: PL/SQL source is too large.

Action: Make it smaller, or contact Worldwide Customer Support.

VAS-02402: Unable to refresh Refresh Group name?

Cause: Could not refresh the Refresh Group.

Action: Check to see if the Refresh Group is locked. Try it again after some time.

VAS-02603: The Minimum field must contain a numeric value.

Cause: A non-numeric value has been entered in the Minimum field.

Action: Enter a numeric value in the Minimum field.

VAS-02604: The Maximum field must contain a numeric value.

Cause: A non-numeric value has been entered in the Maximum field.

Action: Enter a numeric value in the Maximum field.

VAS-02605: The Increment field must contain a numeric value.

Cause: A non-numeric value has been entered in the Increment field.

Action: Enter a numeric value in the Increment field.

VAS-02606: The Initial field must contain a numeric value.

Cause: A non-numeric value has been entered in the Initial field.

Action: Enter a numeric value in the Initial field.

VAS-02607: The Cache Size field must contain a numeric value.

Cause: A non-numeric value has been entered in the Cache Size field.

Action: Enter a numeric value in the Cache Size field.

VAS-02608: The number of values of CACHE must be greater than 1.

Cause: Negative Cache Size.

Action: Enter a positive Cache Size value.

VAS-03202: Please specify the schema with the object you want to create the synonym for.

Cause: You did not specify the schema with the object you want to create the synonym for.

Action: Specify the schema with the object you want to create the synonym for.

VAS-03203: Please specify the object for which you wish to create the synonym.

Cause: You did not specify an object.

Action: Specify the object for which you wish to create the Synonym.

VAS-03402: A constraint cannot define both unique and primary key columns.

Cause: Both unique and primary constraints are checked for a column.

Action: Remove a unique or primary key constraint from the column.

VAS-03404: Insufficient number of clustered columns.

Cause: An attempt was made to create a table with fewer cluster columns than were specified in the CREATE CLUSTER statement. The CLUSTER clause of a CREATE TABLE statement must specify all cluster columns that were defined when the cluster was created.

Action: Specify all cluster columns in the CREATE TABLE statement.

VAS-03405: A table needs at least one column.

Cause: There are no columns in this table.

Action: Use the New button to create a column.

VAS-03406: Columns added will be deleted! Do you want to continue?

Cause: There are no columns in this table.

Action: Use the New button to create a column.

VAS-03408: A primary key constraint has already been defined.

Cause: A primary key already exists.

Action: Remove the previously defined primary key and define a new one.

VAS-03450: The Column Length field must contain a numeric value.

Cause: A non-numeric value has been entered in the Column Length field.

Action: Enter a numeric value in the Column Length field.

VAS-03451: The Column Precision field must contain a numeric value.

Cause: A non-numeric value has been entered in the Column Precision field.

Action: Enter a numeric value in the Column Precision field.

VAS-03452: The Table Name field must contain a valid Oracle identifier.

Cause: The text you entered in the Table Name field is not a valid Oracle identifier.

Action: Make sure the entered value conforms to the guidelines for Oracle identifiers in Oracle7 Server SQL Reference.

VAS-03453: The Column Name field must contain a valid Oracle identifier.

Cause: The text you entered in the Column Name field is not a valid Oracle identifier.

Action: Make sure the entered value conforms to the guidelines for Oracle identifiers in Oracle7 Server SQL Reference.

VAS-03454: Column name already exists.

Cause: Column with the same name already exists.

Action: Enter a unique column name.

VAS-03455: Specify column(s) for the Primary Key.

Cause: No column selected for the primary key.

Action: Specify column(s) for the Primary Key.

VAS-03456: Specify Referenced Table for column name.

Cause: No referenced table specified for the Foreign Key.

Action: Specify referenced table for the column.

VAS-03457: Specify Referenced Column for column name.

Cause: No referenced column specified for the Foreign Key.

Action: Specify referenced column for the column.

VAS-03458: Specify Check Condition Column for column name.

Cause: No check condition specified for the column.

Action: Specify check condition for the column.

VAS-03459: Specify Length for column name.

Cause: No length specified for the column.

Action: Specify length for the column.

VAS-03460: The Initial Extent Size field must contain a numeric value.

Cause: A non-numeric value has been entered in the Initial Extent Size field.

Action: Enter a numeric value in the Initial Extent Size field.

VAS-03461: The Next Extent Size field must contain a numeric value.

Cause: A non-numeric value has been entered in the Next Extent Size field.

Action: Enter a numeric value in the Next Extent Size field.

VAS-03462: The Increment Extent Size field must contain a numeric value.

Cause: A non-numeric value has been entered in the Increment Extent Size field.

Action: Enter a numeric value in the Increment Extent Size field.

VAS-03463: The Minimum Extent Number field must contain a numeric value.

Cause: A non-numeric value has been entered in the Minimum Extent Number field.

Action: Enter a numeric value in the Minimum Extent Number field.

VAS-03464: The Maximum Extent Number field must contain a numeric value.

Cause: A non-numeric value has been entered in the Maximum Extent Number field.

Action: Enter a numeric value in the Maximum Extent Number field.

VAS-03465: The Percentage Free Space field must contain a numeric value.

Cause: A non-numeric value has been entered in the Percentage Free Space field.

Action: Enter a numeric value in the Percentage Free Space field.

VAS-03466: The Percentage Used Space field must contain a numeric value.

Cause: A non-numeric value has been entered in the Percentage Used Space field.

Action: Enter a numeric value in the Percentage Used Space field.

VAS-03467: The Initial Transactions field must contain a numeric value.

Cause: A non-numeric value has been entered in the Initial Transactions field.

Action: Enter a numeric value in the Initial Transactions field.

VAS-03468: The Maximum Transactions field must contain a numeric value.

Cause: A non-numeric value has been entered in the Maximum Transactions field.

Action: Enter a numeric value in the Maximum Transactions field.

VAS-03469: The Free Lists field must contain a numeric value.

Cause: A non-numeric value has been entered in the Free Lists field.

Action: Enter a numeric value in the Free Lists field.

VAS-03470: The Free Groups field must contain a numeric value.

Cause: A non-numeric value has been entered in the Free Groups field.

Action: Enter a numeric value in the Free Groups field.

VAS-03471: Long and Long raw data types are not supported for autocalculation of storage parameters.

Cause: Used long or long raw as column type.

Action: Enter a numeric value

VAS-04000: Create Like is not supported for PL/SQL objects with compressed source.

Cause: You attempted to perform a Create Like of a compressed PL/SQL object.

Action: Select a non-compressed PL/SQL object or perform a simple Create instead of Create Like.

VAS-04001: Unknown exception type caught.

Cause: Unknown

Action: Contact Oracle Worldwide Customer Support.

VAS-06047: The High Value field must contain a valid entry.

Cause: The high value entered is either blank or invalid.

Action: Check to make sure the value entered conforms to the guidelines in Oracle 8 manual.

---