Oracle Error Messages: 01/25/12

Wednesday, 25 January 2012

ORA-02373: Error parsing insert statement for table string.

ORA-02373: Error parsing insert statement for table string.

Cause: self-evident.

Action: Check the error given below this one.

ORA-02372: data for row: string

ORA-02372: data for row: string

Cause: A conversion error occurred while loading data into a table. The message shows values for the field in the row that had the conversion error.

Action: None. This is only an informational message.

ORA-02371: Loader must be at least version string.string.string.string.string for direct path

ORA-02371: Loader must be at least version string.string.string.string.string for direct path

Cause: The loader being used is incompatible with this version of the kernel.

Action: Upgrade your loader to at least the specified version or use the conventional path.

ORA-02368: file string is not valid for this load operation

ORA-02368: file string is not valid for this load operation

Cause: The specified file could not be used for this load because the internal header and or or table metadata of this file were not consistent with those of the first file listed in the DUMPFILE clause.

Action: Verify all the files listed in the DUMPFILE clause are from the same unload operation.

ORA-02367: file truncated error in string

ORA-02367: file truncated error in string

Cause: A truncated or incomplete file was used for the load operation.

Action: Verify unload operation completed successfully.

ORA-02366: The following index(es) on table string were processed:

ORA-02366: The following index(es) on table string were processed:

Cause: The table had some indexes which were loaded if there were no errors.

Action: none.

ORA-02365: error seeking in file: string

ORA-02365: error seeking in file: string

Cause: An attempt to seek to the specified position in file failed.

Action: Review the error message. Resolve the problem and retry the the operation. Contact Oracle Support Services if

ORA-02364: error writing to file: string

ORA-02364: error writing to file: string

Cause: An attempt to write to the specified file for data export or import failed.

Action: Review the error message. Resolve the problem and retry the the operation. Contact Oracle Support Services if

ORA-02363: error reading from file: string

ORA-02363: error reading from file: string

Cause: An attempt to read from the specified file for data export or import failed.

Action: Review the error message. Resolve the problem and retry the the operation. Contact Oracle Support Services if the problem cannot be resolved.

ORA-02362: error closing file: string

ORA-02362: error closing file: string

Cause: An attempt to close the specified file for data export or import failed.

Action: Review the error message. Resolve the problem and retry the the operation. Contact Oracle Support Services if the problem cannot be resolved.

ORA-02361: error while attempting to allocate number bytes of memory

ORA-02361: error while attempting to allocate number bytes of memory

Cause: d by insufficient memory.

Action: Reconnect to the instance and retry the operation.

ORA-02360: fatal error during data export or import initialization

ORA-02360: fatal error during data export or import initialization

Cause: An unexpected error occurred during initialization for data export or import.

Action: Contact Oracle Support Services.

ORA-02359: internal error setting attribute string

ORA-02359: internal error setting attribute string

Cause: An attempt to set information about an internal object failed.

Action: Contact Oracle Support Services.

ORA-02358: internal error fetching attribute string

ORA-02358: internal error fetching attribute string

Cause: An attempt to fetch information about an internal object failed.

Action: Contact Oracle Support Services.

ORA-02357: no valid dump files

ORA-02357: no valid dump files

Cause: None of the dump files for the operation were valid. A minimum of one valid dump file is expected.

Action: Check that the dump files exist and are openable.

ORA-02356: The database is out of space. The load cannot continue

ORA-02356: The database is out of space. The load cannot continue

Cause: The load was discontinued due to space exhaustion in the database.

Action: Add space for the specified table.

ORA-02355: error opening file: string

ORA-02355: error opening file: string

Cause: An attempt to open the specified file for data export or import failed.

Action: Review the error message. Resolve the problem and retry the the operation. Contact Oracle Support Services if the problem cannot be resolved.

ORA-02354: error in exporting or importing data string

ORA-02354: error in exporting or importing data string

Cause: An error has occurred in a stream export or import operation. This message will be followed by another message giving more details about this error.

Action: See export or import documentation for an explanation of the second error message.

ORA-02353: files not from the same unload operation

ORA-02353: files not from the same unload operation

Cause: Files used for the load operation were not from the same unload operation.

Action: Verify the files used are from the same unload operation.

ORA-02352: file truncated error

ORA-02352: file truncated error

Cause: A truncated file was used for the load operation.

Action: Verify unload operation completed successfully.

ORA-02351: internal error: string

ORA-02351: internal error: string

Cause: An unexpected error condition was detected.

Action: Call Oracle Customer Support.

ORA-02349: invalid user-defined type - type is incomplete

ORA-02349: invalid user-defined type - type is incomplete

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.

ORA-02348: cannot create VARRAY column with embedded LOB

ORA-02348: cannot create VARRAY column with embedded LOB

Cause: An attempt was made to create a column of a VARRAY type which has an embedded LOB attribute. The LOB could be an attribute of a subtype of the declared type of VARRAY s element.

Action: Remove offending attribute from type. If it is a subtype attribute then declare the VARRAY column NOT SUBSTITUTABLE.

ORA-02347: cannot grant privileges on columns of an object table

ORA-02347: cannot grant privileges on columns of an object table

Cause: An attempt was made to grant privileges on the columns of an object table.

Action: none

ORA-02345: cannot create a view with column based on CURSOR operator

ORA-02345: cannot create a view with column based on CURSOR operator

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.

ORA-02344: cannot revoke execute on a type with table dependents

ORA-02344: cannot revoke execute on a type with table dependents

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.

ORA-02342: replacement type has compilation errors

ORA-02342: replacement type has compilation errors

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.

ORA-02340: invalid column specification

ORA-02340: invalid column specification

Cause: An attempt was made to specify an UNPACKED column within a packed table.

Action: Remove the UNPACKED keyword in the column specification.

ORA-02339: invalid column specification

ORA-02339: invalid column specification

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.

ORA-02338: missing or invalid column constraint specification

ORA-02338: missing or invalid column constraint specification

Cause: A column constraint was not specified.

Action: Remove the column specification or specify a column constraint. Then retry the operation.

ORA-02337: not an object type column

ORA-02337: not an object type column

Cause: An attempt was made to use dotted notation on a non-ADT 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.

ORA-02336: column attribute cannot be accessed

ORA-02336: column attribute cannot be accessed

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.

ORA-02335: invalid datatype for cluster column

ORA-02335: invalid datatype for cluster 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.

ORA-02334: cannot infer type for column

ORA-02334: cannot infer type for column

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.

ORA-02333: cannot create constraints on attributes of this column

ORA-02333: cannot create constraints on attributes of this column

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.

ORA-02332: cannot create index on attributes of this column

ORA-02332: cannot create index on attributes of this column

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.

ORA-02331: cannot create constraint on column of datatype string

ORA-02331: cannot create constraint on column of datatype string

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.

ORA-02330: datatype specification not allowed

ORA-02330: datatype specification not allowed

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.

ORA-02329: column of datatype string cannot be unique or a primary key

ORA-02329: column of datatype string cannot be unique or a primary key

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.

ORA-02327: cannot create index on expression with datatype string

ORA-02327: cannot create index on expression with datatype string

Cause: An attempt was made to create an index on a non-indexable expression.

Action: Change the column datatype or do not create the index on an expression whose datatype is one of VARRAY, nested table, object, LOB, or REF.

ORA-02324: more than one column in the SELECT list of THE subquery

ORA-02324: more than one column in the SELECT list of THE subquery

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.

ORA-02322: failure in accessing storage table of the nested table column

ORA-02322: failure in accessing storage table of the nested table column

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.

ORA-02320: failure in creating storage table for nested table column string

ORA-02320: failure in creating storage table for nested table column string

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.

ORA-02315: incorrect number of arguments for default constructor

ORA-02315: incorrect number of arguments for default constructor

Cause: The number of arguments specified for the default constructor doesn t match the number of attributes of the object type.

Action: Specify the correct number of arguments for the default constructor and retry the operation.

ORA-02314: illegal use of type constructor

ORA-02314: illegal use of type constructor

Cause: The statement contains an illegal use of a type constructor.

Action: Refer to the SQL Reference manual for the correct statement syntax.

ORA-02313: object type contains non-queryable type string attribute

ORA-02313: object type contains non-queryable type string attribute

Cause: The specified object type contains a nested attribute whose type is non-queryable.

Action: Use an object type with queryable attribute types.

ORA-02311: cannot alter with COMPILE option a valid type with type or table dependents

ORA-02311: cannot alter with COMPILE option a valid type with type or table dependents

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.

ORA-02310: exceeded maximum number of allowable columns in table

ORA-02310: exceeded maximum number of allowable columns in table

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.

ORA-02309: atomic NULL violation

ORA-02309: atomic NULL violation

Cause: An attempt was made to acess the attributes of a NULL object instance.

Action: Ensure that the object instance is non-NULL before accessing.

ORA-02308: invalid option string for object type column

ORA-02308: invalid option string for object type column

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.

ORA-02307: cannot alter with REPLACE option a type that is not valid

ORA-02307: cannot alter with REPLACE option a type that is not valid

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.

ORA-02306: cannot create a type that already has valid dependent(s)

ORA-02306: cannot create a type that already has valid dependent(s)

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.

ORA-02305: only EXECUTE, DEBUG, and UNDER privileges are valid for types

ORA-02305: only EXECUTE, DEBUG, and UNDER privileges are valid for types

Cause: An attempt was made to GRANT or REVOKE an invalid privilege (not EXECUTE, DEBUG, or UNDER) on a type.

Action: GRANT or REVOKE only the EXECUTE, DEBUG, or UNDER privilege on types.

ORA-02304: invalid object identifier literal

ORA-02304: invalid object identifier literal

Cause: An attempt was made to enter an object identifier literal for CREATE TYPE that is either: - not a string of 32 hexadecimal characters the type

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.

ORA-02303: cannot drop or replace a type with type or table dependents

ORA-02303: cannot drop or replace a type with type or table dependents

Cause: An attempt was made to drop or replace a type that has dependents. There could be a substitutable column of a supertype of the type being dropped.

Action: Drop all type(s) and table(s) depending on the type, then retry the operation using the VALIDATE option, or use the FORCE option.