Oracle 11g Error Codes and Solution Suggestions from ORA-02300 to ORA-02400

Posted on by Fatih Acar

Oracle 11g Error Codes and Solution Suggestions from ORA-02300 to ORA-02400

ORA-02300: invalid value for OIDGENERATORS
Cause: A number was not specified for the value of OIDGENERATORS.
Action: Specify a number for OIDGENERATORS.
ORA-02301: maximum number of OIDGENERATORS is 255
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.
ORA-02302: invalid or missing type name
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.
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.
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
– an object identifier that already identifies an existing object
– an object identifier different from the original object identifier already assigned to 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-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-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-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-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-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-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-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-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-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-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-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-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-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-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-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-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-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-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-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-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-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-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-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-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-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-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-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-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-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-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-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-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-02351: internal error: string
Cause: An unexpected error condition was detected.
Action: Make a note of the error number and message and contact Oracle Support Services.
ORA-02352: error setting an OCI attribute: string
Cause: An OCI error has occurred.
Action: The table or column referenced may not be accessible. Contact Oracle Support Services if the problem cannot be resolved.
ORA-02353: error fetching an OCI attribute: string
Cause: An OCI error has occurred.
Action: The table or column referenced may not be accessible. Contact Oracle Support Services if the problem cannot be resolved.
ORA-02354: error in exporting/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/import documentation for an explanation of the second error message.
ORA-02355: error opening file: string
Cause: An attempt to open the specified file for data export/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-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-02357: header in file string may not contain correct information
Cause: The header may be corrupted.
Action: Contact Oracle Support Services.
ORA-02358: error in exporting or importing data
Cause: An error has occurred in a stream export or import operation.
Action: Contact Oracle Support Services.
ORA-02359: database version in file string is not valid
Cause: The specified file could not be used for this load because its database version was not compatible with the database version in the other files in the DUMPFILE clause.
Action: Verify all the files in the DUMPFILE clause are from the same unload operation.
ORA-02360: fatal error during data export/import initialization
Cause: An unexpected error occurred during initialization for data export/import.
Action: Contact Oracle Support Services.
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-02362: error closing file: string
Cause: An attempt to close the specified file for data export/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-02363: error reading from file: string
Cause: An attempt to read from the specified file for data export/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-02364: error writing to file: string
Cause: An attempt to write to the specified file for data export/import failed.
Action: Review the error message. Resolve the problem and retry the the operation. Contact Oracle Support Services if
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-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-02367: read ended but had expected more data from file string
Cause: A truncated or incomplete file was used for the load operation.
Action: Verify unload operation completed successfully and that the files had not been accidentally truncated.
ORA-02368: the following file is not valid for this load operation
Cause: A file could not be used for this load. See the following message for more information.
Action: Verify all the files in the DUMPFILE clause are from the same unload operation and that the unload was successful.
ORA-02369: internal number in header in file string is not valid
Cause: The specified file could not be used for this load because the internal number in the header was not valid.
Action: If the dump files were transferred over, verify the transfer operation was done correctly.
ORA-02370: internal metadata in file string is not valid
Cause: The specified file could not be used for this load because the internal metadata stored in this file does not match the metadata stored in the first file piece set.
Action: Verify all the files in the DUMPFILE clause are from the same unload operation.
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-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-02373: Error parsing insert statement for table string.
Cause: self-evident.
Action: Check the error given below this one.
ORA-02374: conversion error loading table string.string
Cause: A row could not be loaded into the table because there was a conversion error for one or more columns in a row.
Action: See the message that follows for more information about the row that could not be loaded. To avoid this error, make sure the definition of the table being imported matches the definition of the table being exported.
ORA-02375: conversion error loading table string.string partition string
Cause: A row could not be loaded into the table because there was a conversion error for one or more columns in a row.
Action: See the message that follows for more information about the row that could not be loaded. To avoid this error, make sure the definition of the table being imported matches the definition of the table being exported.
ORA-02376: invalid or redundant resource
Cause: a create, or alter profile command which names a resource not yet defined, or try to specify same resource twice.
Action: define resource first
ORA-02377: invalid resource limit
Cause: specifying limit of 0
Action: specify limit > 0
ORA-02379: profile string already exists
Cause: Try to create a profile which already exist
Action: None
ORA-02380: profile string does not exist
Cause: Try to assign a user to a non-existant profile
Action: None
ORA-02381: cannot drop PUBLIC_DEFAULT profile
Cause: Try to drop PUBLIC_DEFAULT profile
Action: None
ORA-02383: illegal cost factor
Cause: Negative or UNLIMITED cost for this resourc
Action: None
ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit
Cause: An attempt was made to exceed the maximum number of concurrent sessions allowed by the SESSION_PER_USER clause of the user profile.
Action: End one or more concurrent sessions or ask the database administrator to increase the SESSION_PER_USER limit of the user profile.
ORA-02396: exceeded maximum idle time, please connect again
Cause: as stated
Action: None
ORA-02397: exceeded PRIVATE_SGA limit, you are being logged off
Cause: Only when using TP monitor
Action: expand limit
ORA-02398: exceeded procedure space usage
Cause: Stored procedured used up too much space in SYSTEM Tablespace
Action: Use less stored procedure
ORA-02399: exceeded maximum connect time, you are being logged off
Cause: As stated
Action: None
ORA-02400: explain plan output buffer size limit exceeded
Cause: Internally this error is raised and caught to handle cases where the plan output exceeds te buffer size. The output is truncated in cases.
Action: This error should never be seen externally.

Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload CAPTCHA.