{"id":2124,"date":"2016-08-18T13:50:06","date_gmt":"2016-08-18T10:50:06","guid":{"rendered":"http:\/\/www.fatihacar.com\/blog\/?p=2124"},"modified":"2016-12-13T13:51:32","modified_gmt":"2016-12-13T10:51:32","slug":"oracle-12c-r2-error-codes-and-solution-suggestions-from-ora-02300-to-ora-02500","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/oracle-12c-r2-error-codes-and-solution-suggestions-from-ora-02300-to-ora-02500\/","title":{"rendered":"Oracle 12c R2 Error Codes and Solution Suggestions from ORA-02300 to ORA-02500"},"content":{"rendered":"

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-02300 to ORA-02500<\/strong><\/p>\n

\n
ORA-02300: invalid value for OIDGENERATORS<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A number was not specified for the value of OIDGENERATORS.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a number for OIDGENERATORS.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02301: maximum number of OIDGENERATORS is 255<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A number greater than 255 was specified for the value of OIDGENERATORS.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Make sure the number specified for OIDGENERATORS does not exceed 255.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02302: invalid or missing type name<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An invalid or missing type name was entered in a statement.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Enter a valid type name in the statement and retry the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02303: cannot drop or replace a type with type or table dependents<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to drop or replace a type that has type or table dependents.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0For DROP TYPE, drop all type(s) and table(s) depending on the type and then retry the operation, or use the FORCE option. For CREATE TYPE, drop all type(s) and table(s) depending on the type and then retry the operation, or drop all table(s) depending on the type and retry with the FORCE option.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02304: invalid object identifier literal<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An 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<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Do 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.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02305: only EXECUTE, DEBUG, and UNDER privileges are valid for types<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to GRANT or REVOKE an invalid privilege (not EXECUTE, DEBUG, or UNDER) on a type.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0GRANT or REVOKE only the EXECUTE, DEBUG, or UNDER privilege on types.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02306: cannot create a type that already has valid dependent(s)<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An 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).<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Drop the dependents first before creating the type, or do not create the type.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02307: cannot alter with REPLACE option a type that is not valid<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to ALTER with REPLACE option a type that is not valid.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use the CREATE OR REPLACE TYPE command to modify the type.<\/span><\/span>
\n<\/p>\n

\n
<\/a> ORA-02308: invalid option\u00a0string<\/i>\u00a0for object type column<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to specify an invalid option, such as PACKED or UNPACKED, for the object type column.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the invalid option from column specification and retry the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02309: atomic NULL violation<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to acess the attributes of a NULL object instance.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the object instance is non-NULL before accessing.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02310: exceeded maximum number of allowable columns in table<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The attributes in the object type column exceeded the maximum number of columns allowed in a table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify fewer attributes for the object type and retry the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02311: cannot alter with COMPILE option a valid type with type or table dependents<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to ALTER with COMPILE option a type that is valid and has type or table dependents.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0No need to perform this operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02313: object type contains non-queryable type\u00a0string<\/i>\u00a0attribute<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified object type contains a nested attribute whose type is non-queryable.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use an object type with queryable attribute types.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02314: illegal use of type constructor<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The statement contains an illegal use of a type constructor.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Refer to the SQL Reference manual for the correct statement syntax.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02315: incorrect number of arguments for default constructor<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The number of arguments specified for the default constructor doesn’t match the number of attributes of the object type.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify the correct number of arguments for the default constructor and retry the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02320: failure in creating storage table for nested table column\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred while creating the storage table for the specified nested table column.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0See the messages that follow for more details. If the situation they describe can be corrected, do so; otherwise contact Oracle Support.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02322: failure in accessing storage table of the nested table column<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occured while performing DML on the storage table of the nested table column.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0If the situation described in the following messages can be corrected, do so; otherwise contact Oracle Support.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02324: more than one column in the SELECT list of THE subquery<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0More than one column was selected in the THE subquery.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify only one column in the SELECT list of the THE subquery and retry the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02327: cannot create index on expression with datatype\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to create an index on a non-indexable expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Change the column datatype or do not create the index on an expression whose datatype is one of VARRAY, nested table, object, LOB, or REF.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02329: column of datatype\u00a0string<\/i>\u00a0cannot be unique or a primary key<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An 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.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Change the column datatype or remove the constraint. Then retry the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02330: datatype specification not allowed<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to specify the data type in the column constraint specification of an object table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove data type specification and retry the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02331: cannot create constraint on column of datatype\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to create a constraint on a column posessing a non-constrainable datatype — VARRAY, nested table, object, LOB, FILE, or REF.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Change the column datatype, or remove the constraint.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02332: cannot create index on attributes of this column<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to create an index on an attributes of an object type column.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Do not specify the index on the attribute.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02333: cannot create constraints on attributes of this column<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to create a constraint on an attribute of an object type column.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the constraint or change the object type.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02334: cannot infer type for column<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A 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.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Declare a datatype for the column.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02335: invalid datatype for cluster column<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to declare a CLUSTER column of datatype object, REF, nested table, VARRAY, LOB, or FILE.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the CLUSTER column or change the datatype of the column.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02336: column attribute cannot be accessed<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to extract an attribute of an object type column.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Change the object type for the column and retry the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02337: not an object type column<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to use dotted notation on a non-ADT column; that is, “a.b.c” where “a” is not an object type.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Either change the column type to an object type or do not perform this operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02338: missing or invalid column constraint specification<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A column constraint was not specified.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the column specification or specify a column constraint. Then retry the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02339: invalid column specification<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to specify the PACKED or UNPACKED keyword for a non-object type column.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the PACKED or UNPACKED keyword in the column specification and retry the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02340: invalid column specification<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to specify an UNPACKED column within a packed table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the UNPACKED keyword in the column specification.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02342: replacement type has compilation errors<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The use of the ALTER…REPLACE statement on a valid type caused a compilation error.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use the ALTER…REPLACE statement to replace the type with a valid type which does not cause compilation errors.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02344: cannot revoke execute on a type with table dependents<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to revoke execute on a type that has dependents.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Drop all table(s) depending on the type, then retry the operation, or use the FORCE option.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02345: cannot create a view with column based on CURSOR operator<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A CURSOR operator was used as one of the SELECT elements in the subquery of a CREATE VIEW or CREATE TABLE … AS SELECT statement.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the CURSOR operator and replace it with the CAST operator.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02347: cannot grant privileges on columns of an object table<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to grant privileges on the columns of an object table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0n\/a<\/span><\/span><\/p>\n

\n
<\/a> ORA-02348: cannot create VARRAY column with embedded LOB<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An 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.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove offending attribute from type. If it is a subtype attribute then declare the VARRAY column NOT SUBSTITUTABLE.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02349: invalid user-defined type – type is incomplete<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to use an incomplete type definition as a column or table datatype.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Complete the type definition and retry the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02351: internal error:\u00a0string<\/i>\\n<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An unexpected error condition was detected.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Make a note of the error number and message and contact Oracle Support Services.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02352: error setting an OCI attribute:\u00a0string<\/i>\\n<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An OCI error has occurred.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0The table or column referenced may not be accessible. Contact Oracle Support Services if the problem cannot be resolved.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02353: error fetching an OCI attribute:\u00a0string<\/i>\\n<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An OCI error has occurred.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0The table or column referenced may not be accessible. Contact Oracle Support Services if the problem cannot be resolved.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02354: error in exporting\/importing data\\nstring<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error has occurred in a stream export or import operation. This message will be followed by another message giving more details about this error.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0See export\/import documentation for an explanation of the second error message.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02355: error opening file:\u00a0string<\/i>\\n<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt to open the specified file for data export\/import failed.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Review the error message. Resolve the problem and retry the the operation. Contact Oracle Support Services if the problem cannot be resolved.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02356: The database is out of space. The load cannot continue<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The load was discontinued due to space exhaustion in the database.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Add space for the specified table.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02357: header in file\u00a0string<\/i>\u00a0may not contain correct information\\n<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The header may be corrupted.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact Oracle Support Services.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02358: error in exporting or importing data\\n<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error has occurred in a stream export or import operation.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact Oracle Support Services.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02359: database version in file\u00a0string<\/i>\u00a0is not valid\\n<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The 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.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Verify all the files in the DUMPFILE clause are from the same unload operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02360: fatal error during data export\/import initialization\\n<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An unexpected error occurred during initialization for data export\/import.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact Oracle Support Services.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02361: error while attempting to allocate\u00a0number<\/i>\u00a0bytes of memory\\n<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred while trying to allocate memory. This is likely caused by insufficient memory.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Reconnect to the instance and retry the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02362: error closing file:\u00a0string<\/i>\\n<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt to close the specified file for data export\/import failed.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Review the error message. Resolve the problem and retry the the operation. Contact Oracle Support Services if the problem cannot be resolved.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02363: error reading from file:\u00a0string<\/i>\\n<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt to read from the specified file for data export\/import failed.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Review the error message. Resolve the problem and retry the the operation. Contact Oracle Support Services if the problem cannot be resolved.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02364: error writing to file:\u00a0string<\/i>\\n<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt to write to the specified file for data export or import failed.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Review the error message. Resolve the problem and retry the the operation. Contact Oracle Support Services if the problem cannot be resolved.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02365: error seeking in file:\u00a0string<\/i>\\n<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt to seek to the specified position in file failed.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Review the error message. Resolve the problem and retry the the operation. Contact Oracle Support Services if the problem cannot be resolved.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02366: The following index(es) on table\u00a0string<\/i>\u00a0were processed:<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The table had some indexes which were loaded if there were no errors.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0None<\/span><\/span><\/p>\n

\n
<\/a> ORA-02367: read ended but had expected more data from file\u00a0string<\/i>\\n<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A truncated or incomplete file was used for the load operation.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Verify unload operation completed successfully and that the files had not been accidentally truncated.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02368: the following file is not valid for this load operation\\n<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A file could not be used for this load. See the following message for more information.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Verify all the files in the DUMPFILE clause are from the same unload operation and that the unload was successful.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02369: internal number in header in file\u00a0string<\/i>\u00a0is not valid\\n<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified file could not be used for this load because the internal number in the header was not valid.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0If the dump files were transferred over, verify the transfer operation was done correctly.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02370: internal metadata in file\u00a0string<\/i>\u00a0is not valid\\n<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The 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.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Verify all the files in the DUMPFILE clause are from the same unload operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02371: Loader must be at least version\u00a0string<\/i>.string<\/i>.string<\/i>.string<\/i>.string<\/i>\u00a0for direct path<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The loader being used is incompatible with this version of the kernel.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Upgrade your loader to at least the specified version or use the conventional path.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02372: data for row:\u00a0string<\/i>\u00a0\\n<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A conversion error occurred while loading data into a table. The message shows values for the field in the row that had the conversion error.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0None. This is only an informational message.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02373: Error parsing insert statement for table\u00a0string<\/i>.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0self-evident.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the error given below this one.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02374: conversion error loading table\u00a0string<\/i>.string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A row could not be loaded into the table because there was a conversion error for one or more columns in a row.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0See 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.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02375: conversion error loading table\u00a0string<\/i>.string<\/i>\u00a0partition\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A row could not be loaded into the table because there was a conversion error for one or more columns in a row.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0See 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.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02376: invalid or redundant resource<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0a create, or alter profile command which names a resource not yet defined, or try to specify same resource twice.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0define resource first<\/span><\/span><\/p>\n

\n
<\/a> ORA-02377: invalid profile limit\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A value of 0 or lower was specified for the limit.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a limit greater than 0. For password profile parameters, some additional restrictions apply: * For the INACTIVE_ACCOUNT_TIME profile parameter, the specified limit cannot be less than 15 days. * For the PASSWORD_GRACE_TIME profile parameter, 0 is allowed as a permissible value.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02378: duplicate resource name\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-02379: profile\u00a0string<\/i>\u00a0already exists<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Try to create a profile which already exist<\/span><\/span><\/p>\n

Action:<\/b>\u00a0n\/a<\/span><\/span><\/p>\n

\n
<\/a> ORA-02380: profile\u00a0string<\/i>\u00a0does not exist<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Try to assign a user to a non-existant profile<\/span><\/span><\/p>\n

Action:<\/b>\u00a0n\/a<\/span><\/span><\/p>\n

\n
<\/a> ORA-02381: cannot drop PUBLIC_DEFAULT profile<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Try to drop PUBLIC_DEFAULT profile<\/span><\/span><\/p>\n

Action:<\/b>\u00a0n\/a<\/span><\/span><\/p>\n

\n
<\/a> ORA-02382: profile\u00a0string<\/i>\u00a0has users assigned, cannot drop without CASCADE<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-02383: illegal cost factor<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Negative or UNLIMITED cost for this resourc<\/span><\/span><\/p>\n

Action:<\/b>\u00a0n\/a<\/span><\/span><\/p>\n

\n
<\/a> ORA-02390: exceeded COMPOSITE_LIMIT, you are being logged off<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to exceed the maximum number of concurrent sessions allowed by the SESSION_PER_USER clause of the user profile.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0End one or more concurrent sessions or ask the database administrator to increase the SESSION_PER_USER limit of the user profile.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02392: exceeded session limit on CPU usage, you are being logged off<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-02393: exceeded call limit on CPU usage<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-02394: exceeded session limit on IO usage, you are being logged off<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-02395: exceeded call limit on IO usage<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-02396: exceeded maximum idle time, please connect again<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0as stated<\/span><\/span><\/p>\n

Action:<\/b>\u00a0n\/a<\/span><\/span><\/p>\n

\n
<\/a> ORA-02397: exceeded PRIVATE_SGA limit, you are being logged off<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Only when using TP monitor<\/span><\/span><\/p>\n

Action:<\/b>\u00a0expand limit<\/span><\/span><\/p>\n

\n
<\/a> ORA-02398: exceeded procedure space usage<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Stored procedured used up too much space in SYSTEM Tablespace<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use less stored procedure<\/span><\/span><\/p>\n

\n
<\/a> ORA-02399: exceeded maximum connect time, you are being logged off<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0As stated<\/span><\/span><\/p>\n

Action:<\/b>\u00a0n\/a<\/span><\/span><\/p>\n

\n
<\/a> ORA-02401: cannot EXPLAIN view owned by another user<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The view specified in the SQL statement belongs to another user and cannot be explained.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Create a view with the same definition that belongs to current user.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02402: PLAN_TABLE not found<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The table used by EXPLAIN to store row source information does not exist in the current schema.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Create a plan table in the current schema or use the INTO clause of the statement to put the results of the explain command in an existing plan table.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02403: plan table does not have correct format<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The explicit plan table does not have the appropriate field definitions.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Redefine the plan table to have the appropriate field definitions.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02404: specified plan table not found<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified plan table does cannot be found.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Create the specified plan table or use an existing plan table.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02405: invalid sql plan object provided<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The user provided a NULL, empty, or malformed object of type SQL_PLAN_TABLE_TYPE<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Provide a new, properly formed object to the function<\/span><\/span><\/p>\n

\n
<\/a> ORA-02420: missing schema authorization clause<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0the AUTHORIZATION clause is missing from a create schema statement.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Preceed the schema authorization identifier with the AUTHORIZATION keyword.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02421: missing or invalid schema authorization identifier<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0the schema name is missing or is incorrect in an authorization clause of a create schema statement.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0If the name is present, it must be the same as the current schema.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02422: missing or invalid schema element<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A statement other than a create table, create view, or grant privilege appears in a create schema statement.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Self-evident.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02423: schema name does not match schema authorization identifier<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0a table definition with a schema name prepended to the table name does not match the schema name provided in the authorization clause of a create schema statement.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0make sure the schema names match.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02424: potential circular view references or unknown referenced tables<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0the create schema statement contains views that depend on other views in the containing create schema statement or they contain references to unknown tables.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0create the dependent views in a separate create schema statement and make sure all referenced tables are either defined in the create schema statement or exist outside the statement.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02425: create table failed<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0a create table statement failed in the create schema statement.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0the cause for failure will be presented below this error message. Follow appropriate action(s) as suggested by the subsequent error message.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02426: privilege grant failed<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0a grant privilege statement failed inthe create schema statement.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0the cause for failure will be presented below this error message. Follow appropriate action(s) as suggested by the subsequent error message.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02427: create view failed<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0a create view statement failed in the create schema statement.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0the cause for failure will be presented below this error message. Follow appropriate action(s) as suggested by the subsequent error message.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02428: could not add foreign key reference<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0could not add a foreign key reference because of error in declaration. Either referenced table does not exist or table does not have an unique key.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0make sure referenced table exists and\/or has unique key<\/span><\/span><\/p>\n

\n
<\/a> ORA-02429: cannot drop index used for enforcement of unique\/primary key<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0user attempted to drop an index that is being used as the enforcement mechanism for unique or primary key.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0drop the constraint instead of the index.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02430: cannot enable constraint (string<\/i>) – no such constraint<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0the named constraint does not exist for this table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Obvious<\/span><\/span><\/p>\n

\n
<\/a> ORA-02431: cannot disable constraint (string<\/i>) – no such constraint<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0the named constraint does not exist for this table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Obvious<\/span><\/span><\/p>\n

\n
<\/a> ORA-02432: cannot enable primary key – primary key not defined for table<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Attempted to enable a primary key that is not defined for the table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Need to add a primary key definition for the table.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02433: cannot disable primary key – primary key not defined for table<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Attempted to disable a primary key tht is not defined for the table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0None<\/span><\/span><\/p>\n

\n
<\/a> ORA-02434: cannot enable unique(string<\/i>) – unique key not defined for table<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0attempted to enable a unique key that is not defined for the table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0None<\/span><\/span><\/p>\n

\n
<\/a> ORA-02435: cannot disable unique(string<\/i>) – unique key not defined for table<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0attempted to disable a unique key that is not deined for the table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0None<\/span><\/span><\/p>\n

\n
<\/a> ORA-02436: date or system variable wrongly specified in CHECK constraint<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to use a date constant or system variable, such as USER, in a check constraint that was not completely specified in a CREATE TABLE or ALTER TABLE statement. For example, a date was specified without the century.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Completely specify the date constant or system variable. Setting the event 10149 allows constraints like “a1 > ’10-MAY-96′”, which a bug permitted to be created before version 8.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02437: cannot validate (string<\/i>.string<\/i>) – primary key violated<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0attempted to validate a primary key with duplicate values or null values.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0remove the duplicates and null values before enabling a primary key.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02438: Column check constraint cannot reference other columns<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0attempted to define a column check constraint that references another column.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0define it as a table check constriant.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02439: Unique index on a deferrable constraint is not allowed<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0attempted to enable a deferrable primary key\/unique constraint that has an existing unique index on the constraint columns.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Drop the index on the constraint columns or make the constraint not deferrable.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02440: Create as select with referential constraints not allowed<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0create table foo (… ref. con. …) as select …;<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Create the table as select, then alter the table to add the constraints afterwards.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02441: Cannot drop nonexistent primary key<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0alter table drop primary key – primary key does not exist.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0None<\/span><\/span><\/p>\n

\n
<\/a> ORA-02442: Cannot drop nonexistent unique key<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0alter table drop unique (col list<\/i>) – unique specification does not exist.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0make sure column list for unique constraint is correct.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02443: Cannot drop constraint – nonexistent constraint<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0alter table drop constraint <constraint_name><\/span><\/span><\/p>\n

Action:<\/b>\u00a0make sure you supply correct constraint name.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02444: Cannot resolve referenced object in referential constraints<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0attempted to define foreign key referencing an object which cannot be resolved to a base table reference<\/span><\/span><\/p>\n

Action:<\/b>\u00a0referential constraints can only be defined on objects which can be resolve to base table reference<\/span><\/span><\/p>\n

\n
<\/a> ORA-02445: Exceptions table not found<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0the explicity or implicity declared exceptions table does not exist.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Create the table then issue the enable command again.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02446: CREATE TABLE … AS SELECT failed – check constraint violated<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to use a CREATE TABLE … AS SELECT statement when some rows violated one or more CHECK constraints.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Do not select rows that violate constraints.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02447: cannot defer a constraint that is not deferrable<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to defer a nondeferrable constraint<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Drop the constraint and create a new one that is deferrable<\/span><\/span><\/p>\n

\n
<\/a> ORA-02448: constraint does not exist<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The named constraint does not exist<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Stop trying to do something with a nonexistant constraint<\/span><\/span><\/p>\n

\n
<\/a> ORA-02449: unique\/primary keys in table referenced by foreign keys<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to drop a table with unique or primary keys referenced by foreign keys in another table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Before performing the above operations the table, drop the foreign key constraints in other tables. You can see what constraints are referencing a table by issuing the following command: SELECT * FROM USER_CONSTRAINTS WHERE TABLE_NAME = “tabnam”;<\/span><\/span><\/p>\n

\n
<\/a> ORA-02450: Invalid hash option – missing keyword IS<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Missing IS keyword.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify HASH IS option.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02451: duplicate HASHKEYS specification<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The HASHKEYS option is specified more than once.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Only specify the HASHKEYS option once.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02452: invalid HASHKEYS option value<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified HASHKEYS option must be an integer value.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify an appropriate value.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02453: duplicate HASH IS specification<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The HASH IS option is specified more than once.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0only specify the HASH IS option once.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02454: Number of hash keys per block (string<\/i>) exceeds maximum of\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The SIZE argument is too small.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Increase the SIZE argument.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02455: The number of cluster key column must be 1<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0When specifing the HASH IS option, the number of key columns must be 1.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Either do not specify the HASH IS option or reduce the number of key columns.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02456: The HASH IS column specification must be NUMBER(*,0)<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The column specification must specify an integer.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify the column definition as type NUMBER(precision, 0).<\/span><\/span><\/p>\n

\n
<\/a> ORA-02457: The HASH IS option must specify a valid column<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The HASH IS column name is not specified in the cluster definition.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a valid column name.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02458: HASHKEYS must be specified for a HASH CLUSTER<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The HASHKEYS option must be specified when creating a HASH CLUSTER.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify the HASHKEYS option.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02459: Hashkey value must be a positive integer<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The value of the hash key was not a positive number.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a positive integer.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02460: Inappropriate index operation on a hash cluster<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt to create a cluster index was issued on a hash cluster.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Do not attempt to create such an index.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02461: Inappropriate use of the INDEX option<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0This option is only valid for non hash clusters.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Do not specify this option.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02462: Duplicate INDEX option specified<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The INDEX option is specified more than once.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Only specify the INDEX option once.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02463: Duplicate HASH IS option specified<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The HASH IS option is specified more than once.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Only specify the HASH IS option once.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02464: Cluster definition can not be both HASH and INDEX<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The cluster can either be a hash or indexed cluster – not both.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove either the HASH IS or INDEX options.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02465: Inappropriate use of the HASH IS option<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0This option is only valid for clusters<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Do not specify this option<\/span><\/span><\/p>\n

\n
<\/a> ORA-02466: The SIZE and INITRANS options cannot be altered for HASH CLUSTERS.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to change the SIZE and INITRANS options after the hash cluster was created.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Do not specify this option.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02467: Column referenced in expression not found in cluster definition<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A column in the hash is expression was not present in cluster definition.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Recreate the cluster and correct the error in hash expression.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02468: Constant or system variable wrongly specified in expression<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A constant or system variable was specified in the hash expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Recreate the cluster and correct the error in hash expression.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02469: Hash expression does not return an Oracle Number.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Result of evaluating hash expression is not an Oracle Number.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Recreate the cluster and correct the error in hash expression.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02470: TO_DATE, USERENV, or SYSDATE incorrectly used in hash expression.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to specify SYSDATE, UID, USER, ROWNUM, or LEVEL in hash expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Re-create the cluster and correct the error in hash expression.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02471: SYSDATE, UID, USER, ROWNUM, or LEVEL incorrectly used in hash expression.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0SYSDATE, UID, USER, ROWNUM, or LEVEL are not allowed in hash expressions.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Recreate the cluster and remove the offending keywords.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02472: PL\/SQL functions not allowed in hash expressions<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A PL\/SQL function was used in the hash expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Recreate the cluster and remove the PL\/SQL function.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02473: Error while evaluating the cluster’s hash expression.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred while evaluating the clusters hash expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the query and retry.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02474: Fixed hash area extents used (string<\/i>) exceeds maximum allowed (string<\/i>)<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The number of extents required for creating the fixed hash area exceeds the maximum number allowed.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Reduce the number of extents required by increasing the extent allocation sizes within the STORAGE clause.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02475: maximum cluster chain block count of\u00a0string<\/i>\u00a0has been exceeded<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The number of blocks in a cluster chain exceeds the maximum number allowed.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Increase SIZE parameter in CREATE CLUSTER statement or reconsider suitability of cluster key.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02476: can not create index due to parallel direct load on table<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A parallel direct load is occurring to the specified table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Retry statement after load is complete.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02477: can not perform parallel direct load on object\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A parallel direct load is not possible because an index is is being created on the table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Retry load after index creation is complete.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02478: merge into base segment would overflow MAXEXTENTS limit<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Merge of temporary segment into base segment failed because MAXEXTENTS was larger than the total in the temp and base segments<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use a larger value for MAXEXTENTS on the base segment or make the extents in the temporary segments larger<\/span><\/span><\/p>\n

\n
<\/a> ORA-02479: error while translating file name for parallel load<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An invalid file name was specified to load data into.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a valid database file.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02481: Too many processes specified for events (max\u00a0string<\/i>)<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Too many processes specified than allowed per event.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Enter fewer processes by using ranges or wildcards if possible.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02482: Syntax error in event specification (string<\/i>)<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Illegal event string<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Enter a legal event string<\/span><\/span><\/p>\n

\n
<\/a> ORA-02483: Syntax error in process specification (string<\/i>)<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Illegal process string<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Enter a legal process string<\/span><\/span><\/p>\n

\n
<\/a> ORA-02484: Invalid _trace_buffers parameter specification (string<\/i>)<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Bad process or size in _trace_buffers INIT.ORA parameter.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0n\/a<\/span><\/span><\/p>\n

\n
<\/a> ORA-02485: Invalid _trace_options parameter specification (string<\/i>)<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Bad syntax for _trace_options INIT.ORA parameter.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0n\/a<\/span><\/span><\/p>\n

\n
<\/a> ORA-02486: Error in writing trace file\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Error occurred in creating\/writing the file.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check file name and make sure it is constructed properly. Also, check permissions for directories.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02487: Error in converting trace data<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Incompatible binary trace data was specified.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the format of the input data.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02488: Error encountered when accessing file [string<\/i>] for trace conversion<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to open or access the trace file during a trace conversion.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the permissions for both input and output files. Also, check the file compatibility for the trace conversion.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02490: missing required file size in RESIZE clause<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0No value was specified for the RESIZE clause.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use correct syntax.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02491: missing required keyword ON or OFF in AUTOEXTEND clause<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The keyword ON or OFF was not specified for the AUTOEXTEND clause.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use correct syntax.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02492: missing required file block increment size in NEXT clause<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0No value was specified for the NEXT clause.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use correct syntax.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02493: invalid file increment size in NEXT clause<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A non-integer value was used for the NEXT clause of the DATAFILE list.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use correct syntax.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02494: invalid or missing maximum file size in MAXSIZE clause<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0UNLIMITED was not specified, or an invalid integer value was specified, for the MAXSIZE clause in the DATAFILE file list. The MAXSIZE value cannot be smaller than the SIZE value.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use correct syntax.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02495: cannot resize file\u00a0string<\/i>, tablespace\u00a0string<\/i>\u00a0is read only<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to resize a data file in a tablespace that is read only.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Change the tablespace to read\/write and retry the resize operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02496: cannot alter or drop an individual chunk tablespace<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to alter or drop an individual chunk tablespace which is part of a tablespace set.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use alter or drop only on the tablespace set.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02500: IN SHARD option already specified<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0In the CREATE TABLESPACE, the IN SHARD option was specified more than once.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove all but one of the IN SHARD options.<\/span><\/span><\/p>\n

\n
<\/dd>\n<\/dl>\n","protected":false},"excerpt":{"rendered":"

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-02300 to ORA-02500 ORA-02300: invalid value for OIDGENERATORS Cause:\u00a0A number was not specified for the value of OIDGENERATORS. Action:\u00a0Specify a number for OIDGENERATORS. ORA-02301: maximum number of OIDGENERATORS is 255 Cause:\u00a0A number greater than 255 was specified for the value of OIDGENERATORS. Action:\u00a0Make sure the number…<\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":true,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[53],"tags":[54],"class_list":["post-2124","post","type-post","status-publish","format-standard","hentry","category-oracle-errors-and-solutions","tag-oracle-error-solutions"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p39NFI-yg","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2124","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/comments?post=2124"}],"version-history":[{"count":2,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2124\/revisions"}],"predecessor-version":[{"id":2126,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2124\/revisions\/2126"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=2124"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=2124"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=2124"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}