Release 8.0.4
A58312-01
 Library |
 Product |
 Contents |
 Index |
| Oracle8 Error Messages Release 8.0.4 A58312-01 |
|
Cause: A number was not specified for the value of OIDGENERATORS.
Action: Specify a number after OIDGENERATORS.
Cause: A number greater than 255 was specified for the value of OIDGENERATORS.
Action: Make sure the number specified for OIDGENERATORS does not exceed 255.
Cause: An invalid or missing type name was entered in a statement.
Action: Enter a valid type name in the statement and retry the operation.
Cause: An attempt was made to drop or replace a type that has dependents.
Action: Drop all type(s) and table(s) depending on the type, then retry the operation or use the FORCE option.
Cause: An attempt was made to enter an object identifier literal for CREATE TYPE that is either:
Action: Do not specify the object identifier clause or specify a 32 hexadecimal-character object identifier literal that is unique or identical to the originally assigned object identifier. Then retry the operation.
Cause: An attempt was made to GRANT or REVOKE an invalid privilege (not EXECUTE) on a type.
Action: GRANT or REVOKE only the EXECUTE privilege on types.
Cause: An attempt was made to create a type that already has some valid dependent(s) (these dependents depend on the fact that the type does not exist).
Action: Drop the dependents first before creating the type, or do not create the type.
Cause: An attempt was made to ALTER with REPLACE option a type that is not valid.
Action: Use the CREATE OR REPLACE TYPE command to modify the type.
Cause: An attempt was made to specify an invalid option, such as PACKED or UNPACKED, for the object type column.
Action: Remove the invalid option from column specification and retry the operation.
Cause: An attempt was made to access the attributes of a NULL object instance.
Action: Ensure that the object instance is non-NULL before accessing.
Cause: The attributes in the object type column exceeded the maximum number of columns allowed in a table.
Action: Specify fewer attributes for the object type and retry the operation.
Cause: An attempt was made to ALTER with COMPILE option a type that is valid and has type or table dependents.
Action: No need to perform this operation.
Cause: An attempt was made to create extent table for VALUE Object Type.
Action: Specify object type when creating extent table.
Cause: The specified object type contains a nested attribute whose type is non-queryable.
Action: Use an object type with queryable attribute types.
Cause: The number of arguments specified for the default constructor does not match the number of attributes of the object type.
Action: Specify the correct number of arguments for the default constructor and retry the operation.
Cause: An error occurred while creating the storage table for the specified nested table column.
Action: See the messages that follow for more details. If the situation they describe can be corrected, do so; otherwise contact Oracle Support.
Cause: An error occured while performing DML on the storage table of the nested table column.
Action: If the situation described in the following messages can be corrected, do so; otherwise contact Oracle Support.
Cause: More than one column was selected in the THE subquery.
Action: Specify only one column in the SELECT list of the THE subquery and retry the operation.
Cause: An attempt was made to create an index on a non-indexable column.
Action: Change the column datatype or do not create the index on a column whose datatype is one of VARRAY, nested table, object, LOB, or REF.
Cause: An attempt was made to place a UNIQUE or a PRIMARY KEY constraint on a column of datatype VARRAY, nested table, object, LOB, FILE or REF.
Action: Change the column datatype or remove the constraint. Then retry the operation.
Cause: An attempt was made to specify the data type in the column constraint specification of an object table.
Action: Remove data type specification and retry the operation.
Cause: An attempt was made to create a constraint on a column posessing a non-constrainable datatype -- VARRAY, nested table, object, LOB, FILE, or REF.
Action: Change the column datatype, or remove the constraint.
Cause: An attempt was made to create an index on an attributes of an object type column.
Action: Do not specify the index on the attribute.
Cause: An attempt was made to create a constraint on an attribute of an object type column.
Action: Remove the constraint or change the object type.
Cause: A datatype was not declared for this column (in the CREATE TABLE) and an attempt was made to create a constraint on an attribute of this column.
Action: Declare a datatype for the column.
Cause: An attempt was made to declare a CLUSTER column of datatype object, REF, nested table, VARRAY, LOB, or FILE.
Action: Remove the CLUSTER column or change the datatype of the column.
Cause: An attempt was made to extract an attribute of an object type column.
Action: Change the object type for the column and retry the operation.
Cause: An attempt was made to use dotted notation on a non-object type column; that is, "a.b.c" where "a" is not an object type.
Action: Either change the column type to an object type or do not perform this operation.
Cause: A column constraint was not specified.
Action: Remove the column specification or specify a column constraint. Then retry the operation.
Cause: An attempt was made to specify the PACKED or UNPACKED keyword for a non-object type column.
Action: Remove the PACKED or UNPACKED keyword in the column specification and retry the operation.
Cause: An attempt was made to specify an UNPACKED column within a packed table.
Action: Remove the UNPACKED keyword in the column specification.
Cause: Attempt to refer to an object type attribute that is of a non-queryable type in SQL.
Action: Change attribute type to a SQL-queryable type, or reference the attribute through a 3GL.
Cause: The use of the ALTER...REPLACE statement on a valid type caused a compilation error.
Action: Use the ALTER...REPLACE statement to replace the type with a valid type which does not cause compilation errors.
Cause: An attempt was made to cascade drop a user whose type(s) have dependent(s) in other schemas.
Action: The dependent(s) in the other schema must first be dropped before the user can be dropped.
Cause: An attempt was made to revoke execute on a type that has dependents.
Action: Drop all table(s) depending on the type, then retry the operation, or use the FORCE option.
Cause: A CURSOR operator was used as one of the SELECT elements in the subquery of a CREATE VIEW or CREATE TABLE ... AS SELECT statement.
Action: Remove the CURSOR operator and replace it with the CAST operator.
Cause: An attempt was made to grant privileges on the columns of an object table.
Action: Choose another table. Privileges cannot be granted on columns of an object table.
Cause: An attempt was made to use an incomplete type definition as a column or table datatype.
Action: Complete the type definition and retry the operation.
