{"id":1748,"date":"2016-03-04T08:54:49","date_gmt":"2016-03-04T05:54:49","guid":{"rendered":"http:\/\/www.fatihacar.com\/blog\/?p=1748"},"modified":"2016-10-21T08:56:39","modified_gmt":"2016-10-21T05:56:39","slug":"oracle-11g-error-codes-and-solution-suggestions-from-ora-02400-to-ora-02500","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/oracle-11g-error-codes-and-solution-suggestions-from-ora-02400-to-ora-02500\/","title":{"rendered":"Oracle 11g Error Codes and Solution Suggestions from ORA-02400 to ORA-02500"},"content":{"rendered":"

Oracle 11g Error Codes and Solution Suggestions from ORA-02400 to ORA-02500<\/strong><\/p>\n

\n
ORA-02400: explain plan output buffer size limit exceeded<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Internally this error is raised and caught to handle cases where the plan output exceeds te buffer size. The output is truncated in cases.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0This error should never be seen externally.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02401: cannot EXPLAIN view owned by another user<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The view specified in the SQL statement belongs to another user and cannot be explained.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Create a view with the same definition that belongs to current user.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02402: PLAN_TABLE not found<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The table used by EXPLAIN to store row source information does not exist in the current schema.<\/span><\/span><\/span><\/dd>\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><\/span><\/dd>\n
<\/a><\/a>ORA-02403: plan table does not have correct format<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The explicit plan table does not have the appropriate field definitions.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Redefine the plan table to have the appropriate field definitions.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02404: specified plan table not found<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The specified plan table does cannot be found.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Create the specified plan table or use an existing plan table.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02405: invalid sql plan object provided<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The user provided a NULL, empty, or malformed object of type SQL_PLAN_TABLE_TYPE<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Provide a new, properly formed object to the function<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02420: missing schema authorization clause<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0the AUTHORIZATION clause is missing from a create schema statement.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Preceed the schema authorization identifier with the AUTHORIZATION keyword.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02421: missing or invalid schema authorization identifier<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0the schema name is missing or is incorrect in an authorization clause of a create schema statement.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0If the name is present, it must be the same as the current schema.<\/span><\/span><\/span><\/dd>\n

<\/p>\n

<\/a><\/a>ORA-02422: missing or invalid schema element<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A statement other than a create table, create view, or grant privilege appears in a create schema statement.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Self-evident.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02423: schema name does not match schema authorization identifier<\/span><\/b><\/span><\/span><\/dt>\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><\/span><\/dd>\n
Action:<\/b>\u00a0make sure the schema names match.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02424: potential circular view references or unknown referenced tables<\/span><\/b><\/span><\/span><\/dt>\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><\/span><\/dd>\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><\/span><\/dd>\n
<\/a><\/a>ORA-02425: create table failed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0a create table statement failed in the create schema statement.<\/span><\/span><\/span><\/dd>\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><\/span><\/dd>\n
<\/a><\/a>ORA-02426: privilege grant failed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0a grant privilege statement failed inthe create schema statement.<\/span><\/span><\/span><\/dd>\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><\/span><\/dd>\n
<\/a><\/a>ORA-02427: create view failed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0a create view statement failed in the create schema statement.<\/span><\/span><\/span><\/dd>\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><\/span><\/dd>\n
<\/a><\/a>ORA-02428: could not add foreign key reference<\/span><\/b><\/span><\/span><\/dt>\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><\/span><\/dd>\n
Action:<\/b>\u00a0make sure referenced table exists and\/or has unique key<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02429: cannot drop index used for enforcement of unique\/primary key<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0user attempted to drop an index that is being used as the enforcement mechanism for unique or primary key.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0drop the constraint instead of the index.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02430: cannot enable constraint (string<\/i>) – no such constraint<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0the named constraint does not exist for this table.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Obvious<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02431: cannot disable constraint (string<\/i>) – no such constraint<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0the named constraint does not exist for this table.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Obvious<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02432: cannot enable primary key – primary key not defined for table<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attempted to enable a primary key that is not defined for the table.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Need to add a primary key definition for the table.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02433: cannot disable primary key – primary key not defined for table<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attempted to disable a primary key tht is not defined for the table.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02434: cannot enable unique(string<\/i>) – unique key not defined for table<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0attempted to enable a unique key that is not defined for the table.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02435: cannot disable unique(string<\/i>) – unique key not defined for table<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0attempted to disable a unique key that is not deined for the table.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02436: date or system variable wrongly specified in CHECK constraint<\/span><\/b><\/span><\/span><\/dt>\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><\/span><\/dd>\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><\/span><\/dd>\n
<\/a><\/a>ORA-02437: cannot validate (string<\/i>.string<\/i>) – primary key violated<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0attempted to validate a primary key with duplicate values or null values.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0remove the duplicates and null values before enabling a primary key.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02438: Column check constraint cannot reference other columns<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0attempted to define a column check constraint that references another column.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0define it as a table check constriant.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02439: Unique index on a deferrable constraint is not allowed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0attempted to enable a deferrable primary key\/unique constraint that has an existing unique index on the constraint columns.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Drop the index on the constraint columns or make the constraint not deferrable.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02440: Create as select with referential constraints not allowed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0create table foo (… ref. con. …) as select …;<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Create the table as select, then alter the table to add the constraints afterwards.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02441: Cannot drop nonexistent primary key<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0alter table drop primary key – primary key does not exist.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02442: Cannot drop nonexistent unique key<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0alter table drop unique (<col list>) – unique specification does not exist.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0make sure column list for unique constraint is correct.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02443: Cannot drop constraint – nonexistent constraint<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0alter table drop constraint <constraint_name><\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0make sure you supply correct constraint name.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02444: Cannot resolve referenced object in referential constraints<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0attempted to define foreign key referencing an object which cannot be resolved to a base table reference<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0referential constraints can only be defined on objects which can be resolve to base table reference<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02445: Exceptions table not found<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0the explicity or implicity declared exceptions table does not exist.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Create the table then issue the enable command again.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02446: CREATE TABLE … AS SELECT failed – check constraint violated<\/span><\/b><\/span><\/span><\/dt>\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><\/span><\/dd>\n
Action:<\/b>\u00a0Do not select rows that violate constraints.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02447: cannot defer a constraint that is not deferrable<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to defer a nondeferrable constraint<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Drop the constraint and create a new one that is deferrable<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02448: constraint does not exist<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The named constraint does not exist<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Stop trying to do something with a nonexistant constraint<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02449: unique\/primary keys in table referenced by foreign keys<\/span><\/b><\/span><\/span><\/dt>\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><\/span><\/dd>\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><\/span><\/dd>\n
<\/a><\/a>ORA-02450: Invalid hash option – missing keyword IS<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Missing IS keyword.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify HASH IS option.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02451: duplicate HASHKEYS specification<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The HASHKEYS option is specified more than once.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Only specify the HASHKEYS option once.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02452: invalid HASHKEYS option value<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The specified HASHKEYS option must be an integer value.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify an appropriate value.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02453: duplicate HASH IS specification<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The HASH IS option is specified more than once.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0only specify the HASH IS option once.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02454: Number of hash keys per block (string<\/i>) exceeds maximum of\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The SIZE argument is too small.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Increase the SIZE argument.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02455: The number of cluster key column must be 1<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0When specifing the HASH IS option, the number of key columns must be 1.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Either do not specify the HASH IS option or reduce the number of key columns.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02456: The HASH IS column specification must be NUMBER(*,0)<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The column specification must specify an integer.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify the column definition as type NUMBER(precision, 0).<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02457: The HASH IS option must specify a valid column<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The HASH IS column name is not specified in the cluster definition.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify a valid column name.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02458: HASHKEYS must be specified for a HASH CLUSTER<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The HASHKEYS option must be specified when creating a HASH CLUSTER.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify the HASHKEYS option.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02459: Hashkey value must be a positive integer<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The value of the hash key was not a positive number.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify a positive integer.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02460: Inappropriate index operation on a hash cluster<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt to create a cluster index was issued on a hash cluster.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not attempt to create such an index.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02461: Inappropriate use of the INDEX option<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0This option is only valid for non hash clusters.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not specify this option.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02462: Duplicate INDEX option specified<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The INDEX option is specified more than once.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Only specify the INDEX option once.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02463: Duplicate HASH IS option specified<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The HASH IS option is specified more than once.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Only specify the HASH IS option once.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02464: Cluster definition can not be both HASH and INDEX<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The cluster can either be a hash or indexed cluster – not both.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Remove either the HASH IS or INDEX options.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02465: Inappropriate use of the HASH IS option<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0This option is only valid for clusters<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not specify this option<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02466: The SIZE and INITRANS options cannot be altered for HASH CLUSTERS.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to change the SIZE and INITRANS options after the hash cluster was created.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not specify this option.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02467: Column referenced in expression not found in cluster definition<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A column in the hash is expression was not present in cluster definition.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Recreate the cluster and correct the error in hash expression.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02468: Constant or system variable wrongly specified in expression<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A constant or system variable was specified in the hash expression.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Recreate the cluster and correct the error in hash expression.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02469: Hash expression does not return an Oracle Number.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Result of evaluating hash expression is not an Oracle Number.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Recreate the cluster and correct the error in hash expression.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02470: TO_DATE, USERENV, or SYSDATE incorrectly used in hash expression.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0TO_DATE, USERENV and SYSDATE are not allowed in hash expressions.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Recreate the cluster and correct the error in hash expression.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02471: SYSDATE, UID, USER, ROWNUM, or LEVEL incorrectly used in hash expre\\ssion.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0SYSDATE, UID, USER, ROWNUM, or LEVEL are not allowed in hash expression\\s.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Recreate the cluster and remove the offending keywords.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02472: PL\/SQL functions not allowed in hash expressions<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A PL\/SQL function was used in the hash expression.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Recreate the cluster and remove the PL\/SQL function.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02473: Error while evaluating the cluster’s hash expression.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An error occurred while evaluating the clusters hash expression.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Correct the query and retry.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02474: Fixed hash area extents used (string<\/i>) exceeds maximum allowed (string<\/i>)<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The number of extents required for creating the fixed hash area exceeds the maximum number allowed.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Reduce the number of extents required by increasing the extent allocation sizes within the STORAGE clause.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02475: maximum cluster chain block count of\u00a0string<\/i>\u00a0has been exceeded<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The number of blocks in a cluster chain exceeds the maximum number allowed.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Increase SIZE parameter in CREATE CLUSTER statement or reconsider suitability of cluster key.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02476: can not create index due to parallel direct load on table<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A parallel direct load is occurring to the specified table.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Retry statement after load is complete.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02477: can not perform parallel direct load on object\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A parallel direct load is not possible because an index is is being created on the table.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Retry load after index creation is complete.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02478: merge into base segment would overflow MAXEXTENTS limit<\/span><\/b><\/span><\/span><\/dt>\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><\/span><\/dd>\n
Action:<\/b>\u00a0Use a larger value for MAXEXTENTS on the base segment or make the extents in the temporary segments larger<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02479: error while translating file name for parallel load<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An invalid file name was specified to load data into.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify a valid database file.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02481: Too many processes specified for events (max\u00a0string<\/i>)<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Too many processes specified than allowed per event.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Enter fewer processes by using ranges or wildcards if possible.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02482: Syntax error in event specification (string<\/i>)<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Illegal event string<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Enter a legal event string<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02483: Syntax error in process specification (string<\/i>)<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Illegal process string<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Enter a legal process string<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02484: Invalid _trace_buffers parameter specification (string<\/i>)<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Bad process or size in _trace_buffers INIT.ORA parameter.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02485: Invalid _trace_options parameter specification (string<\/i>)<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Bad syntax for _trace_options INIT.ORA parameter.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02486: Error in writing trace file\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Error occurred in creating\/writing the file.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check file name and make sure it is constructed properly. Also, check permissions for directories.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02487: Error in converting trace data<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Incompatible binary trace data was specified.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the format of the input data.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02488: Error encountered when accessing file [string<\/i>] for trace conversion<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to open or access the trace file during a trace conversion.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the permissions for both input and output files. Also, check the file compatibility for the trace conversion.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02490: missing required file size in RESIZE clause<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0No value was specified for the RESIZE clause.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use correct syntax.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02491: missing required keyword ON or OFF in AUTOEXTEND clause<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The keyword ON or OFF was not specified for the AUTOEXTEND clause.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use correct syntax.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02492: missing required file block increment size in NEXT clause<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0No value was specified for the NEXT clause.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use correct syntax.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02493: invalid file increment size in NEXT clause<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A non-integer value was used for the NEXT clause of the DATAFILE list.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use correct syntax.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02494: invalid or missing maximum file size in MAXSIZE clause<\/span><\/b><\/span><\/span><\/dt>\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><\/span><\/dd>\n
Action:<\/b>\u00a0Use correct syntax.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02495: cannot resize file\u00a0string<\/i>, tablespace\u00a0string<\/i>\u00a0is read only<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to resize a data file in a tablespace that is read only.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Change the tablespace to read\/write and retry the resize operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-02700: osnoraenv: error translating ORACLE_SID<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Two-task driver could not find the value of ORACLE_SID in the environment.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Make sure that the ORACLE_SID environment variable has been properly set and exported.<\/span><\/span><\/span><\/dd>\n
<\/dd>\n<\/dl>\n","protected":false},"excerpt":{"rendered":"

Oracle 11g Error Codes and Solution Suggestions from ORA-02400 to ORA-02500 ORA-02400: explain plan output buffer size limit exceeded Cause:\u00a0Internally this error is raised and caught to handle cases where the plan output exceeds te buffer size. The output is truncated in cases. Action:\u00a0This error should never be seen externally. ORA-02401: cannot EXPLAIN view owned…<\/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":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[53],"tags":[14,32,54],"class_list":["post-1748","post","type-post","status-publish","format-standard","hentry","category-oracle-errors-and-solutions","tag-database-administration","tag-oracle-administration","tag-oracle-error-solutions"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p39NFI-sc","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1748","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=1748"}],"version-history":[{"count":1,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1748\/revisions"}],"predecessor-version":[{"id":1749,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1748\/revisions\/1749"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=1748"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=1748"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=1748"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}