{"id":2116,"date":"2016-08-17T09:32:11","date_gmt":"2016-08-17T06:32:11","guid":{"rendered":"http:\/\/www.fatihacar.com\/blog\/?p=2116"},"modified":"2016-12-12T09:34:03","modified_gmt":"2016-12-12T06:34:03","slug":"oracle-12c-r2-error-codes-and-solution-suggestions-from-ora-02140-to-ora-02300","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/oracle-12c-r2-error-codes-and-solution-suggestions-from-ora-02140-to-ora-02300\/","title":{"rendered":"Oracle 12c R2 Error Codes and Solution Suggestions from ORA-02140 to ORA-02300"},"content":{"rendered":"

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

\n
ORA-02140: invalid tablespace name<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An identifier does not follow ALTER TABLESPACE.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a tablespace name following ALTER TABLESPACE.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02141: invalid OFFLINE option<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An option other than NORMAL or IMMEDIATE follows OFFLINE.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0The user must either specify no option following OFFLINE or one of the options NORMAL or IMMEDIATE.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02142: missing or invalid ALTER TABLESPACE option<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A valid option was not present.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use one of the valid options: add, rename, default, online, offline, read only, read write, begin, end, no, force, retention guarantee and retention noguarantee.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02143: invalid STORAGE option<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An option other than INITIAL, NEXT, MINEXTENTS, MAXEXTENTS, or PCTINCREASE was specified in the STORAGE clause.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify only valid options.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02144: no option specified for ALTER CLUSTER<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0No ALTER CLUSTER options are specified.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify one or more of the following options: pctfree, pctused, size, storage.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02145: missing STORAGE option<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0No STORAGE options were specified following STORAGE (<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify one or more STORAGE option between the parentheses.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02146: SHARED specified multiple times<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The SHARED option was specified in a CREATE DATABASE statement multiple times.<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-02147: conflicting SHARED\/EXCLUSIVE options<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Both the SHARED and EXCLUSIVE options were specified in a CREATE DATABASE statement.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify SHARED or EXCLUSIVE, but not both.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02148: EXCLUSIVE specified multiple times<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The EXCLUSIVE option was specified in a CREATE DATABASE statement multiple times.<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-02149: Specified partition does not exist<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Partition not found for the object.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Retry with correct partition name.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02150: invalid new tablespace name<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The new tablespace name specified in ALTER TABLESPACE RENAME TO statement was invalid.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Retry with a valid new tablespace name.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02151: invalid tablespace name:\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Oracle cannot create a tablespace whose name starts with ‘_$deleted$’.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Try a different tablespace name.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02152: Invalid ALTER TABLESPACE … RENAME option<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An option other than DATAFILE or TO follows by ALTER TABLESPACE … RENAME.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0The user must specify either DATAFILE or TO following ALTER TABLESPACE … RENAME.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02153: invalid VALUES password string<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An encoded password string does not follow the VALUES clause.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Place a proper encoded password string after the VALUES clause.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02154: a tablespace with the name ‘string<\/i>‘ is found<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt to rename a tablespace to a new name failed because the new name is already used by some other tablespace.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Retry with a different new name.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02155: invalid DEFAULT tablespace identifier<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An identifier does not follow DEFAULT TABLESPACE.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Place a tablespace name after DEFAULT TABLESPACE.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02156: invalid TEMPORARY tablespace identifier<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An identifier does not follow TEMPORARY TABLESPACE.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Place a tablespace name after TEMPORARY TABLESPACE.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02157: no options specified for ALTER USER<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0No options were specified.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify at least one ALTER USER option.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02158: invalid CREATE INDEX option<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An option other than COMPRESS, NOCOMPRESS, PCTFREE, INITRANS, MAXTRANS, STORAGE, TABLESPACE, PARALLEL, NOPARALLEL, RECOVERABLE, UNRECOVERABLE, LOGGING, NOLOGGING, LOCAL, or GLOBAL was specified.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Choose one of the valid CREATE INDEX options.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02159: installed DLM does not support releasable locking mode<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The parameter file specified gc_* parameters that allow locks to be release by the LCK process when not in use. This mode requires additional support from the DLM that is not available.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify configuration parameters that do not require the additional function.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02160: index-organized table can not contain columns of type LONG<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A column of type LONG defined for index-organized table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Do not use columns of type LONG in index-organized tables.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02161: invalid value for MAXLOGFILES<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A number does not follow MAXLOGFILES.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a number after MAXLOGFILES.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02162: invalid value for MAXDATAFILES<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A number does not follow MAXDATAFILES.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a number after MAXDATAFILES.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02163: invalid value for FREELIST GROUPS<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A number does not follow FREELIST GROUPS.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a number after FREELIST GROUPS.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02164: DATAFILE clause specified more than once<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The CREATE DATABASE command contains more than one DATAFILE clause.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify at most one DATAFILE clause.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02165: invalid option for CREATE DATABASE<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An invalid CREATE DATABASE option is present.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify only valid CREATE DATABASE options.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02166: ARCHIVELOG and NOARCHIVELOG specified<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Both ARCHIVELOG and NOARCHIVELOG are specified in a CREATE DATABASE statement.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify at most one of these two options.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02167: LOGFILE clause specified more than once<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The CREATE DATABASE command contains more than one LOGFILE clause.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify at most one LOGFILE clause.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02168: invalid value for FREELISTS<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A number does not follow FREELISTS<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a number after FREELISTS<\/span><\/span><\/p>\n

\n
<\/a> ORA-02169: FREELISTS storage option not allowed<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The user attempted to specify the FREELISTS storage option. This option may only be specified during create table or create index.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove these options and retry the statement.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02170: FREELIST GROUPS storage option not allowed<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The user attempted to specify the FREELIST GROUPS storage option. This option may only be specified during create table and when allow_freelist_groups INIT.ORA is specified.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove this option and retry the statement or set the allow_freelist_groups INIT.ORA parameter.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02171: invalid value for MAXLOGHISTORY<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A number does not follow MAXLOGHISTORY<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a number after MAXLOGHISTORY<\/span><\/span><\/p>\n

\n
<\/a> ORA-02172: The PUBLIC keyword is not appropriate for a disable thread<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The PUBLIC keyword was specified for a disable.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the keyword and resubmit.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02173: invalid option for DROP TABLESPACE<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Either a token other than INCLUDING was found following the tablespace name or some text was found following INCLUDING CONTENTS.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Place nothing or only INCLUDING CONTENTS after the tablespace name.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02174: Missing required thread number<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Must specify thread number after THREAD keyword<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-02175: invalid rollback segment name<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0In the CREATE or DROP ROLLBACK SEGMENT statements, an identifier was not found following ROLLBACK SEGMENT.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Place the segment name following ROLLBACK SEGMENT.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02176: invalid option for CREATE ROLLBACK SEGMENT<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An invalid option was specified in a CREATE ROLLBACK SEGMENT statement.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify one of the valid options: TABLESPACE and STORAGE.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02177: Missing required group number<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Must specify group number after GROUP keyword<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-02178: correct syntax is: SET TRANSACTION READ { ONLY | WRITE }<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0There is a syntax error in the user’s statement.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the syntax as indicated.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02179: valid options: ISOLATION LEVEL { SERIALIZABLE | READ COMMITTED }<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0There is a syntax error in the user’s statement.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the syntax as indicated.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02180: invalid option for CREATE TABLESPACE<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An invalid option appeared.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify one of the valid options: DATAFILE, DEFAULT STORAGE, ONLINE, OFFLINE, FORCE, RETENTION, IN SHARD.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02181: invalid option to ROLLBACK WORK<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A token other than TO follows ROLLBACK [WORK].<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Place nothing or TO SAVEPOINT\u00a0name<\/i>\u00a0after ROLLBACK [WORK].<\/span><\/span><\/p>\n

\n
<\/a> ORA-02182: savepoint name expected<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An identifier does not follow ROLLBACK [WORK] TO [SAVEPOINT].<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Place a savepoint name following TO [SAVEPOINT].<\/span><\/span><\/p>\n

\n
<\/a> ORA-02183: valid options: ISOLATION_LEVEL { SERIALIZABLE | READ COMMITTED }<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0There is a syntax error in the user’s statement.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the syntax as indicated.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02184: resource quotas are not allowed in REVOKE<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0In a revoke statement, a resource quota was specified.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify resource privilege without the quota.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02185: a token other than WORK follows COMMIT<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A token other than WORK follows COMMIT.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Place either nothing or WORK after COMMIT.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02186: tablespace resource privilege may not appear with other privileges<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to grant or revoke a resource quota in the same statement in which other privileges are granted or revoked.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use a separate grant or revoke statement for the resource quota privilege.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02187: invalid quota specification<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The user attempted to grant a tablespace quota above the upper limit.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Grant a smaller tablespace quota.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02188: Cannot enable instance publicly<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to publicly enable a thread associated with an instance.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Leave out the PUBLIC keyword.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02189: ON\u00a0tablespace<\/i>\u00a0required<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0In a grant or revoke statement, the user specified a tablespace quota but did not follow it with the ON\u00a0tablespace<\/i>\u00a0clause.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify the tablespace on which the quota is to be applied with the ON\u00a0tablespace<\/i>\u00a0clause.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02190: keyword TABLES expected<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The keyword TABLES is expected following DROP CLUSTER\u00a0name<\/i>\u00a0INCLUDING.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Place TABLES after INCLUDING.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02191: correct syntax is: SET TRANSACTION USE ROLLBACK SEGMENT\u00a0rbs<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0There is a syntax error in the user’s statement.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the syntax as indicated.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02192: PCTINCREASE not allowed for rollback segment storage clauses<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0pctincrease was specified in a create or alter rollback segment<\/span><\/span><\/p>\n

Action:<\/b>\u00a0reissue statement without the pctincrease clause<\/span><\/span><\/p>\n

\n
<\/a> ORA-02194: event specification syntax error\u00a0string<\/i>\u00a0(minor error\u00a0string<\/i>) near ‘string<\/i>‘<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0There is a syntax error in an event specification.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Fix the error.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02195: Attempt to create\u00a0string<\/i>\u00a0object in a\u00a0string<\/i>\u00a0tablespace<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The object type is inconsistent with a tablespace contents.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Create an object in a different tablespace, or change the user defaults.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02196: PERMANENT\/TEMPORARY option already specified<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0In CREATE TABLESPACE, the PERMANENT and\/or TEMPORARY options were specified more than once.<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-02197: file list already specified<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0In CREATE TABLESPACE, more than one DATAFILE\/TEMPFILE clause was specified.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Merge the DATAFILE\/TEMPFILE clauses into a single clause.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02198: ONLINE\/OFFLINE option already specified<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0In CREATE TABLESPACE, the ONLINE and\/or OFFLINE options were specified more than once.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify at most one of ONLINE or OFFLINE.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02199: missing DATAFILE\/TEMPFILE clause<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A CREATE TABLESPACE statement has no DATAFILE\/TEMPFILE clause.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a DATAFILE\/TEMPFILE clause.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02200: WITH GRANT OPTION not allowed for PUBLIC<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to GRANT to PUBLIC WITH GRANT OPTION.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the WITH GRANT OPTION clause.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02201: sequence not allowed here<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to reference a sequence in a from-list.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0A sequence can only be referenced in a select-list.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02202: no more tables permitted in this cluster<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to create a table in a cluster which already contains 32 tables.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Up to 32 tables may be stored per cluster.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02203: INITIAL storage options not allowed<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The user attempted to alter the INITIAL storage option of a table, cluster, index, or rollback segment. These options may only be specified when the object is created.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove these options and retry the statement.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02204: ALTER, INDEX and EXECUTE not allowed for views<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to grant or revoke an invalid privilege on a view.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Do not attempt to grant or revoke any of ALTER, INDEX, or EXECUTE privileges on views.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02205: only SELECT and ALTER privileges are valid for sequences<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to grant or revoke an invalid privilege on a sequence.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Do not attempt to grant or revoke DELETE, INDEX, INSERT, UPDATE, REFERENCES or EXECUTE privilege on sequences.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02206: duplicate INITRANS option specification<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

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

Action:<\/b>\u00a0Specify INITRANS at most once.<\/span><\/span><\/p>\n

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

Cause:<\/b>\u00a0The INITRANS value is not an integer between 1 and 255 and less than or equal to the MAXTRANS value.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Choose a valid INITRANS value.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02208: duplicate MAXTRANS option specification<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

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

Action:<\/b>\u00a0Specify MAXTRANS at most once.<\/span><\/span><\/p>\n

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

Cause:<\/b>\u00a0The MAXTRANS value is not an integer between 1 and 255 and greater than or equal to the INITRANS value.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Choose a valid MAXTRANS value.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02210: no options specified for ALTER TABLE<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0No ALTER TABLE option was specified.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify at least one alter table option.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02211: invalid value for PCTFREE or PCTUSED<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified value for PCTFREE or PCTUSED is not an integer between 0 and 100.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Choose an appropriate value for the option.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02212: duplicate PCTFREE option specification<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

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

Action:<\/b>\u00a0Specify PCTFREE at most once.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02213: duplicate PCTUSED option specification<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

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

Action:<\/b>\u00a0Specify PCTUSED at most once.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02214: duplicate BACKUP option specification<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The BACKUP option to ALTER TABLE is specified more than once.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify the option at most once.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02215: duplicate tablespace name clause<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0There is more than one TABLESPACE clause in the CREATE TABLE, CREATE INDEX, or CREATE ROLLBACK SEGMENT statement.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify at most one TABLESPACE clause.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02216: tablespace name expected<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A tablespace name was not present where required by the syntax for the failing statement.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a tablespace name where required by the syntax.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02217: duplicate storage option specification<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A storage option (INIITAL, NEXT, MINEXTENTS, MAXEXTENTS, PCTINCREASE) is specified more than once.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify all storage options at most once.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02218: invalid INITIAL storage option value<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

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

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

\n
<\/a> ORA-02219: invalid NEXT storage option value<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

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

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

\n
<\/a> ORA-02220: invalid MINEXTENTS storage option value<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified value must be a positive integer less than or equal to MAXEXTENTS.<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-02221: invalid MAXEXTENTS storage option value<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified value must be a positive integer greater than or equal to MINEXTENTS.<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-02222: invalid PCTINCREASE storage option value<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified value must be a positive integer.<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-02223: invalid OPTIMAL storage option value<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

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

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

\n
<\/a> ORA-02224: EXECUTE privilege not allowed for tables<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to grant or revoke an invalid privilege on a table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Do not attempt to grant or revoke EXECUTE privilege on tables.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02225: only EXECUTE and DEBUG privileges are valid for procedures<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to grant or revoke an invalid privilege on a procedure, function or package.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Do not attempt to grant or revoke any privilege besides EXECUTE or DEBUG on procedures, functions or packages.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02226: invalid MAXEXTENTS value (max allowed:\u00a0string<\/i>)<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The MAXEXTENTS specified is too large for the database block size. This applies only to SYSTEM rollback segment.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a smaller value.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02227: invalid cluster name<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A cluster name of the form [\u00a0identifier<\/i>\u00a0. ]\u00a0identifier<\/i>\u00a0is expected but not present.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Enter an appropriate cluster name.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02228: duplicate SIZE specification<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

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

Action:<\/b>\u00a0Specify the SIZE option at most once.<\/span><\/span><\/p>\n

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

Cause:<\/b>\u00a0The specified value must be an integer number of bytes.<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-02230: invalid ALTER CLUSTER option<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An option other than PCTFREE, PCTUSED, INITRANS, MAXTRANS, STORAGE, or SIZE is specified in an ALTER CLUSTER statement.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify only legal options.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02231: missing or invalid option to ALTER DATABASE<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An option other than ADD, DROP, RENAME, ARCHIVELOG, NOARCHIVELOG, MOUNT, DISMOUNT, OPEN, or CLOSE is specified in the statement.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify only legal options.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02232: invalid MOUNT mode<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A mode other than SHARED or EXCLUSIVE follows the MOUNT keyword in an ALTER DATABASE statement.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify either SHARED, EXCLUSIVE, or nothing following MOUNT.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02233: invalid CLOSE mode<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A mode other than NORMAL or IMMEDIATE follows the CLOSE keyword in an ALTER DATABASE statement.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify either NORMAL, IMMEDIATE, or nothing following CLOSE.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02234: changes to this table are already logged<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0the log table to be added is a duplicate of another<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Don’t add this change log to the system; check that the replication product’s system tables are consistent<\/span><\/span><\/p>\n

\n
<\/a> ORA-02235: this table logs changes to another table already<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0the table to be altered is already a change log for another table<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Don’t log changes to the specified base table to this table; check that the replication product’s system tables are consistent<\/span><\/span><\/p>\n

\n
<\/a> ORA-02236: invalid file name<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A character string literal was not used in the filename list of a LOGFILE, DATAFILE, or RENAME clause.<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-02237: invalid file size<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A non-integer value was specified in the SIZE or RESIZE clause.<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-02238: filename lists have different numbers of files<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0In a RENAME clause in ALTER DATABASE or TABLESPACE, the the number of existing filenames does not equal the number of new filenames.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Make sure there is a new filename to correspond to each existing filename.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02239: there are objects which reference this sequence<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0the sequence to be dropped is still referenced<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Make sure the sequence name is correct, or drop the referencing constraint\/object<\/span><\/span><\/p>\n

\n
<\/a> ORA-02240: invalid value for OBJNO or TABNO<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A number does not follow either OBJNO or TABNO.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a number after OBJNO or TABNO.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02241: must of form EXTENTS (FILE\u00a0n<\/i>\u00a0BLOCK\u00a0n<\/i>\u00a0SIZE\u00a0n<\/i>, …)<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0bad extent storage clause<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-02242: no options specified for ALTER INDEX<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0No options specified.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify at least one of REBUILD, INITRANS, MAXTRANS, or STORAGE.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02243: invalid ALTER INDEX or ALTER MATERIALIZED VIEW option<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An option other than INITRANS, MAXTRANS,or STORAGE is specified in an ALTER INDEX statement or in the USING INDEX clause of an ALTER MATERIALIZED VIEW statement.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify only legal options.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02244: invalid ALTER ROLLBACK SEGMENT option<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The STORAGE option is expected but not found.<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-02245: invalid ROLLBACK SEGMENT name<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An identifier was expected, but not found, following ALTER [PUBLIC] ROLLBACK SEGMENT.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Place a rollback segment name following SEGMENT.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02246: missing EVENTS text<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A character string literal was expected, but not found, following ALTER SESSION SET EVENTS.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Place the string literal containing the events text after EVENTS.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02247: no option specified for ALTER SESSION<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The option SET EVENTS was expected, but not found, following ALTER SESSION.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Place the SET EVENTS option after ALTER SESSION.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02248: invalid option for ALTER SESSION<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Obvious.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0see SQL Language Manual for legal options.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02249: missing or invalid value for MAXLOGMEMBERS<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A valid number does not follow MAXLOGMEMBERS. The value specified must be between 1 and the port-specific maximum number of log file members.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a valid number after MAXLOGMEMBERS.<\/span><\/span><\/p>\n

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

Cause:<\/b>\u00a0The constraint name is missing or invalid.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a valid identifier name for the constraint name.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02251: subquery not allowed here<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Subquery is not allowed here in the statement.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the subquery from the statement.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02252: check constraint condition not properly ended<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified search condition for the check constraint is not properly ended.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0End the condition properly.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02253: constraint specification not allowed here<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Constraint specification is not allowed here in the statement.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the constraint specification from the statement.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02254: DEFAULT\u00a0expression<\/i>\u00a0not allowed here<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Default value expression is not allowed for the column here in the statement.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the default value expression from the statement.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02255: obsolete 7.1.5<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Was that defaults must not conflict with not null constraints<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-02256: number of referencing columns must match referenced columns<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The number of columns in the foreign-key referencing list is not equal to the number of columns in the referenced list.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Make sure that the referencing columns match the referenced columns.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02257: maximum number of columns exceeded<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The number of columns in the key list exceeds the maximum number.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Reduce the number columns in the list.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02258: duplicate or conflicting NULL and\/or NOT NULL specifications<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

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

Action:<\/b>\u00a0Remove the duplicate or conflicting specification.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02259: duplicate UNIQUE\/PRIMARY KEY specifications<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

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

Action:<\/b>\u00a0Remove the duplicate specification.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02260: table can have only one primary key<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

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

Action:<\/b>\u00a0Remove the extra primary key.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02261: such unique or primary key already exists in the table<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

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

Action:<\/b>\u00a0Remove the extra key.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02262: ORA-string<\/i>\u00a0occurs while type-checking column default value expression<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0New column datatype causes type-checking error for existing column default value expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the default value expression or don’t alter the column datatype.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02263: need to specify the datatype for this column<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The required datatype for the column is missing.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify the required datatype.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02264: name already used by an existing constraint<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified constraint name has to be unique.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a unique constraint name for the constraint.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02265: cannot derive the datatype of the referencing column<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The datatype of the referenced column is not defined as yet.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Make sure that the datatype of the referenced column is defined before referencing it.<\/span><\/span><\/p>\n

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

Cause:<\/b>\u00a0An attempt was made to truncate a table with unique or primary keys referenced by foreign keys enabled in another table. Other operations not allowed are dropping\/truncating a partition of a partitioned table or an ALTER TABLE EXCHANGE PARTITION.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Before performing the above operations the table, disable 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-02267: column type incompatible with referenced column type<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The data type or collation of the referencing column was incompatible with the data type or collation of the referenced column.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Select a compatible data type for the referencing column. Also, the collation of a character column in a foreign key must match the collation of the corresponding column in the primary key.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02268: referenced table does not have a primary key<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The referenced table does not have a primary key.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify explicitly the referenced table unique key.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02269: key column cannot be of LONG datatype<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

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

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

\n
<\/a> ORA-02270: no matching unique or primary key for this column-list<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A REFERENCES clause in a CREATE\/ALTER TABLE statement gives a column-list for which there is no matching unique or primary key constraint in the referenced table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Find the correct column names using the ALL_CONS_COLUMNS catalog view<\/span><\/span><\/p>\n

\n
<\/a> ORA-02271: table does not have such constraint<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

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

Action:<\/b>\u00a0Make sure the specified constraint name is correct.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02272: constrained column cannot be of LONG datatype<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

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

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

\n
<\/a> ORA-02273: this unique\/primary key is referenced by some foreign keys<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

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

Action:<\/b>\u00a0Remove all references to the key before the key is to be dropped.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02274: duplicate referential constraint specifications<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

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

Action:<\/b>\u00a0Remove the duplicate specification.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02275: such a referential constraint already exists in the table<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

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

Action:<\/b>\u00a0Remove the extra constraint.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02276: default value type incompatible with column type<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The type of the evaluated default expression is incompatible with the datatype of the column.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Change the type of the column, or modify the default expression.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02277: invalid sequence name<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified sequence name is not a valid identifier name.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a valid identifier name for the sequence name.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02278: duplicate or conflicting MAXVALUE\/NOMAXVALUE specifications<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

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

Action:<\/b>\u00a0Remove the duplicate or conflicting specification.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02279: duplicate or conflicting MINVALUE\/NOMINVALUE specifications<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

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

Action:<\/b>\u00a0Remove the duplicate or conflicting specification.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02280: duplicate or conflicting CYCLE\/NOCYCLE specifications<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

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

Action:<\/b>\u00a0Remove the duplicate or conflicting specification.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02281: duplicate or conflicting CACHE\/NOCACHE specifications<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

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

Action:<\/b>\u00a0Remove the duplicate or conflicting specification.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02282: duplicate or conflicting ORDER\/NOORDER specifications<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

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

Action:<\/b>\u00a0Remove the duplicate or conflicting specification.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02283: cannot alter starting sequence number<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

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

Action:<\/b>\u00a0Don’t alter it.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02284: duplicate INCREMENT BY specifications<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

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

Action:<\/b>\u00a0Remove the duplicate specification.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02285: duplicate START WITH specifications<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

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

Action:<\/b>\u00a0Remove the duplicate specification.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02286: no options specified for ALTER SEQUENCE<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

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

Action:<\/b>\u00a0The statement is meaningless without any options.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02287: sequence number not allowed here<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified sequence number (CURRVAL or NEXTVAL) is inappropriate here in the statement.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the sequence number.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02288: invalid OPEN mode<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A token other than RESETLOGS appears following ALTER DATABASE\u00a0name<\/i>\u00a0OPEN.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Either nothing or RESETLOGS should be placed following OPEN.<\/span><\/span><\/p>\n

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

Cause:<\/b>\u00a0The specified sequence does not exist, or the user does not have the required privilege to perform this operation.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Make sure the sequence name is correct, and that you have the right to perform the desired operation on this sequence.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02290: check constraint (string<\/i>.string<\/i>) violated<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The values being inserted do not satisfy the named check constraint.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0do not insert values that violate the constraint.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02291: integrity constraint (string<\/i>.string<\/i>) violated – parent key not found<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A foreign key value has no matching primary key value.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Delete the foreign key or add a matching primary key.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02292: integrity constraint (string<\/i>.string<\/i>) violated – child record found<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0attempted to delete a parent key value that had a foreign key dependency.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0delete dependencies first then parent or disable constraint.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02293: cannot validate (string<\/i>.string<\/i>) – check constraint violated<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0an alter table operation tried to validate a check constraint to a populated table that had nocomplying values.<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-02294: cannot enable (string<\/i>.string<\/i>) – constraint changed during validation<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0While one DDL statement was attempting to enable this constraint, another DDL changed this same constraint.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Try again, with only one DDL changing the constraint this time.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02295: found more than one enable\/disable clause for constraint<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0a create or alter table specified more than one enable and\/or disable clause for a given constraint.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0only one enable or disable may be specified for a given constraint.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02296: cannot enable (string<\/i>.string<\/i>) – null values found<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0an alter table enable constraint failed because the table contains values that do not satisfy the constraint.<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-02297: cannot disable constraint (string<\/i>.string<\/i>) – dependencies exist<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0an alter table disable constraint failed becuase the table has foriegn keys that are dpendent on this constraint.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Either disable the foreign key constraints or use disable cascade<\/span><\/span><\/p>\n

\n
<\/a> ORA-02298: cannot validate (string<\/i>.string<\/i>) – parent keys not found<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0an alter table validating constraint failed because the table has orphaned child records.<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-02299: cannot validate (string<\/i>.string<\/i>) – duplicate keys found<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0an alter table validating constraint failed because the table has duplicate key values.<\/span><\/span><\/p>\n

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

\n
<\/a> 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
<\/dd>\n<\/dl>\n","protected":false},"excerpt":{"rendered":"

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-02140 to ORA-02300 ORA-02140: invalid tablespace name Cause:\u00a0An identifier does not follow ALTER TABLESPACE. Action:\u00a0Specify a tablespace name following ALTER TABLESPACE. ORA-02141: invalid OFFLINE option Cause:\u00a0An option other than NORMAL or IMMEDIATE follows OFFLINE. Action:\u00a0The user must either specify no option following OFFLINE or one of…<\/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-2116","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-y8","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2116","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=2116"}],"version-history":[{"count":2,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2116\/revisions"}],"predecessor-version":[{"id":2118,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2116\/revisions\/2118"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=2116"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=2116"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=2116"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}