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

Posted on by Fatih Acar

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

ORA-02200: WITH GRANT OPTION not allowed for PUBLIC
Cause: An attempt was made to GRANT to PUBLIC WITH GRANT OPTION.
Action: Remove the WITH GRANT OPTION clause.
ORA-02201: sequence not allowed here
Cause: An attempt was made to reference a sequence in a from-list.
Action: A sequence can only be referenced in a select-list.
ORA-02202: no more tables permitted in this cluster
Cause: An attempt was made to create a table in a cluster which already contains 32 tables.
Action: Up to 32 tables may be stored per cluster.
ORA-02203: INITIAL storage options not allowed
Cause: The 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.
Action: Remove these options and retry the statement.
ORA-02204: ALTER, INDEX and EXECUTE not allowed for views
Cause: An attempt was made to grant or revoke an invalid privilege on a view.
Action: Do not attempt to grant or revoke any of ALTER, INDEX, or EXECUTE privileges on views.
ORA-02205: only SELECT and ALTER privileges are valid for sequences
Cause: An attempt was made to grant or revoke an invalid privilege on a sequence.
Action: Do not attempt to grant or revoke DELETE, INDEX, INSERT, UPDATE, REFERENCES or EXECUTE privilege on sequences.
ORA-02206: duplicate INITRANS option specification
Cause: INITRANS is specified more than once.
Action: Specify INITRANS at most once.
ORA-02207: invalid INITRANS option value
Cause: The INITRANS value is not an integer between 1 and 255 and less than or equal to the MAXTRANS value.
Action: Choose a valid INITRANS value.
ORA-02208: duplicate MAXTRANS option specification
Cause: MAXTRANS is specified more than once.
Action: Specify MAXTRANS at most once.
ORA-02209: invalid MAXTRANS option value
Cause: The MAXTRANS value is not an integer between 1 and 255 and greater than or equal to the INITRANS value.
Action: Choose a valid MAXTRANS value.

ORA-02210: no options specified for ALTER TABLE
Cause: No ALTER TABLE option was specified.
Action: Specify at least one alter table option.
ORA-02211: invalid value for PCTFREE or PCTUSED
Cause: The specified value for PCTFREE or PCTUSED is not an integer between 0 and 100.
Action: Choose an appropriate value for the option.
ORA-02212: duplicate PCTFREE option specification
Cause: PCTFREE option specified more than once.
Action: Specify PCTFREE at most once.
ORA-02213: duplicate PCTUSED option specification
Cause: PCTUSED option specified more than once.
Action: Specify PCTUSED at most once.
ORA-02214: duplicate BACKUP option specification
Cause: The BACKUP option to ALTER TABLE is specified more than once.
Action: Specify the option at most once.
ORA-02215: duplicate tablespace name clause
Cause: There is more than one TABLESPACE clause in the CREATE TABLE, CREATE INDEX, or CREATE ROLLBACK SEGMENT statement.
Action: Specify at most one TABLESPACE clause.
ORA-02216: tablespace name expected
Cause: A tablespace name is not present where required by the syntax for one of the following statements: CREATE/DROP TABLESPACE, CREATE TABLE, CREATE INDEX, or CREATE ROLLBACK SEGMENT.
Action: Specify a tablespace name where required by the syntax.
ORA-02217: duplicate storage option specification
Cause: A storage option (INIITAL, NEXT, MINEXTENTS, MAXEXTENTS, PCTINCREASE) is specified more than once.
Action: Specify all storage options at most once.
ORA-02218: invalid INITIAL storage option value
Cause: The specified value must be an integer.
Action: Choose an appropriate integer value.
ORA-02219: invalid NEXT storage option value
Cause: The specified value must be an integer.
Action: Choose an appropriate integer value.
ORA-02220: invalid MINEXTENTS storage option value
Cause: The specified value must be a positive integer less than or equal to MAXEXTENTS.
Action: Specify an appropriate value.
ORA-02221: invalid MAXEXTENTS storage option value
Cause: The specified value must be a positive integer greater than or equal to MINEXTENTS.
Action: Specify an appropriate value.
ORA-02222: invalid PCTINCREASE storage option value
Cause: The specified value must be a positive integer.
Action: Specify an appropriate value.
ORA-02223: invalid OPTIMAL storage option value
Cause: The specified value must be an integer.
Action: Choose an appropriate integer value.
ORA-02224: EXECUTE privilege not allowed for tables
Cause: An attempt was made to grant or revoke an invalid privilege on a table.
Action: Do not attempt to grant or revoke EXECUTE privilege on tables.
ORA-02225: only EXECUTE and DEBUG privileges are valid for procedures
Cause: An attempt was made to grant or revoke an invalid privilege on a procedure, function or package.
Action: Do not attempt to grant or revoke any privilege besides EXECUTE or DEBUG on procedures, functions or packages.
ORA-02226: invalid MAXEXTENTS value (max allowed: string)
Cause: The MAXEXTENTS specified is too large for the database block size. This applies only to SYSTEM rollback segment.
Action: Specify a smaller value.
ORA-02227: invalid cluster name
Cause: A cluster name of the form [ <identifier> . ] <identifier> is expected but not present.
Action: Enter an appropriate cluster name.
ORA-02228: duplicate SIZE specification
Cause: The SIZE option is specified more than once.
Action: Specify the SIZE option at most once.
ORA-02229: invalid SIZE option value
Cause: The specified value must be an integer number of bytes.
Action: Specify an appropriate value.
ORA-02230: invalid ALTER CLUSTER option
Cause: An option other than PCTFREE, PCTUSED, INITRANS, MAXTRANS, STORAGE, or SIZE is specified in an ALTER CLUSTER statement.
Action: Specify only legal options.
ORA-02231: missing or invalid option to ALTER DATABASE
Cause: An option other than ADD, DROP, RENAME, ARCHIVELOG, NOARCHIVELOG, MOUNT, DISMOUNT, OPEN, or CLOSE is specified in the statement.
Action: Specify only legal options.
ORA-02232: invalid MOUNT mode
Cause: A mode other than SHARED or EXCLUSIVE follows the MOUNT keyword in an ALTER DATABASE statement.
Action: Specify either SHARED, EXCLUSIVE, or nothing following MOUNT.
ORA-02233: invalid CLOSE mode
Cause: A mode other than NORMAL or IMMEDIATE follows the CLOSE keyword in an ALTER DATABASE statement.
Action: Specify either NORMAL, IMMEDIATE, or nothing following CLOSE.
ORA-02234: changes to this table are already logged
Cause: the log table to be added is a duplicate of another
Action: Don’t add this change log to the system; check that the replication product’s system tables are consistent
ORA-02235: this table logs changes to another table already
Cause: the table to be altered is already a change log for another table
Action: Don’t log changes to the specified base table to this table; check that the replication product’s system tables are consistent
ORA-02236: invalid file name
Cause: A character string literal was not used in the filename list of a LOGFILE, DATAFILE, or RENAME clause.
Action: Use correct syntax.
ORA-02237: invalid file size
Cause: A non-integer value was specified in the SIZE or RESIZE clause.
Action: Use correct syntax.
ORA-02238: filename lists have different numbers of files
Cause: In a RENAME clause in ALTER DATABASE or TABLESPACE, the the number of existing filenames does not equal the number of new filenames.
Action: Make sure there is a new filename to correspond to each existing filename.
ORA-02239: there are objects which reference this sequence
Cause: the sequence to be dropped is still referenced
Action: Make sure the sequence name is correct, or drop the referencing constraint/object
ORA-02240: invalid value for OBJNO or TABNO
Cause: A number does not follow either OBJNO or TABNO.
Action: Specify a number after OBJNO or TABNO.
ORA-02241: must of form EXTENTS (FILE <n> BLOCK <n> SIZE <n>, …)
Cause: bad extent storage clause
Action: respecify
ORA-02242: no options specified for ALTER INDEX
Cause: No options specified.
Action: Specify at least one of REBUILD, INITRANS, MAXTRANS, or STORAGE.
ORA-02243: invalid ALTER INDEX or ALTER MATERIALIZED VIEW option
Cause: An 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.
Action: Specify only legal options.
ORA-02244: invalid ALTER ROLLBACK SEGMENT option
Cause: The STORAGE option is expected but not found.
Action: Specify the STORAGE option.
ORA-02245: invalid ROLLBACK SEGMENT name
Cause: An identifier was expected, but not found, following ALTER [PUBLIC] ROLLBACK SEGMENT.
Action: Place a rollback segment name following SEGMENT.
ORA-02246: missing EVENTS text
Cause: A character string literal was expected, but not found, following ALTER SESSION SET EVENTS.
Action: Place the string literal containing the events text after EVENTS.
ORA-02247: no option specified for ALTER SESSION
Cause: The option SET EVENTS was expected, but not found, following ALTER SESSION.
Action: Place the SET EVENTS option after ALTER SESSION.
ORA-02248: invalid option for ALTER SESSION
Cause: Obvious.
Action: see SQL Language Manual for legal options.
ORA-02249: missing or invalid value for MAXLOGMEMBERS
Cause: A valid number does not follow MAXLOGMEMBERS. The value specified must be between 1 and the port-specific maximum number of log file members.
Action: Specify a valid number after MAXLOGMEMBERS.
ORA-02250: missing or invalid constraint name
Cause: The constraint name is missing or invalid.
Action: Specify a valid identifier name for the constraint name.
ORA-02251: subquery not allowed here
Cause: Subquery is not allowed here in the statement.
Action: Remove the subquery from the statement.
ORA-02252: check constraint condition not properly ended
Cause: The specified search condition for the check constraint is not properly ended.
Action: End the condition properly.
ORA-02253: constraint specification not allowed here
Cause: Constraint specification is not allowed here in the statement.
Action: Remove the constraint specification from the statement.
ORA-02254: DEFAULT <expression> not allowed here
Cause: Default value expression is not allowed for the column here in the statement.
Action: Remove the default value expression from the statement.
ORA-02255: obsolete 7.1.5
Cause: Was that defaults must not conflict with not null constraints
Action: None
ORA-02256: number of referencing columns must match referenced columns
Cause: The number of columns in the foreign-key referencing list is not equal to the number of columns in the referenced list.
Action: Make sure that the referencing columns match the referenced columns.
ORA-02257: maximum number of columns exceeded
Cause: The number of columns in the key list exceeds the maximum number.
Action: Reduce the number columns in the list.
ORA-02258: duplicate or conflicting NULL and/or NOT NULL specifications
Cause: Self-evident.
Action: Remove the duplicate or conflicting specification.
ORA-02259: duplicate UNIQUE/PRIMARY KEY specifications
Cause: Self-evident.
Action: Remove the duplicate specification.
ORA-02260: table can have only one primary key
Cause: Self-evident.
Action: Remove the extra primary key.
ORA-02261: such unique or primary key already exists in the table
Cause: Self-evident.
Action: Remove the extra key.
ORA-02262: ORA-string occurs while type-checking column default value expression
Cause: New column datatype causes type-checking error for existing column default value expression.
Action: Remove the default value expression or don’t alter the column datatype.
ORA-02263: need to specify the datatype for this column
Cause: The required datatype for the column is missing.
Action: Specify the required datatype.
ORA-02264: name already used by an existing constraint
Cause: The specified constraint name has to be unique.
Action: Specify a unique constraint name for the constraint.
ORA-02265: cannot derive the datatype of the referencing column
Cause: The datatype of the referenced column is not defined as yet.
Action: Make sure that the datatype of the referenced column is defined before referencing it.
ORA-02266: unique/primary keys in table referenced by enabled foreign keys
Cause: An 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.
Action: Before 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”;
ORA-02267: column type incompatible with referenced column type
Cause: The datatype of the referencing column is incompatible with the
Action: Select a compatible datatype for the referencing column.
ORA-02268: referenced table does not have a primary key
Cause: The referenced table does not have a primary key.
Action: Specify explicitly the referenced table unique key.
ORA-02269: key column cannot be of LONG datatype
Cause: Self-evident.
Action: Change the datatype of the column, or remove the column from the key.
ORA-02270: no matching unique or primary key for this column-list
Cause: A 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.
Action: Find the correct column names using the ALL_CONS_COLUMNS catalog view
ORA-02271: table does not have such constraint
Cause: Self-evident.
Action: Make sure the specified constraint name is correct.
ORA-02272: constrained column cannot be of LONG datatype
Cause: Self-evident.
Action: Change the datatype of the column, or remove the constraint on the column.
ORA-02273: this unique/primary key is referenced by some foreign keys
Cause: Self-evident.
Action: Remove all references to the key before the key is to be dropped.
ORA-02274: duplicate referential constraint specifications
Cause: Self-evident.
Action: Remove the duplicate specification.
ORA-02275: such a referential constraint already exists in the table
Cause: Self-evident.
Action: Remove the extra constraint.
ORA-02276: default value type incompatible with column type
Cause: The type of the evaluated default expression is incompatible with the datatype of the column.
Action: Change the type of the column, or modify the default expression.
ORA-02277: invalid sequence name
Cause: The specified sequence name is not a valid identifier name.
Action: Specify a valid identifier name for the sequence name.
ORA-02278: duplicate or conflicting MAXVALUE/NOMAXVALUE specifications
Cause: Self-evident.
Action: Remove the duplicate or conflicting specification.
ORA-02279: duplicate or conflicting MINVALUE/NOMINVALUE specifications
Cause: Self-evident.
Action: Remove the duplicate or conflicting specification.
ORA-02280: duplicate or conflicting CYCLE/NOCYCLE specifications
Cause: Self-evident.
Action: Remove the duplicate or conflicting specification.
ORA-02281: duplicate or conflicting CACHE/NOCACHE specifications
Cause: Self-evident.
Action: Remove the duplicate or conflicting specification.
ORA-02282: duplicate or conflicting ORDER/NOORDER specifications
Cause: Self-evident.
Action: Remove the duplicate or conflicting specification.
ORA-02283: cannot alter starting sequence number
Cause: Self-evident.
Action: Don’t alter it.
ORA-02284: duplicate INCREMENT BY specifications
Cause: Self-evident.
Action: Remove the duplicate specification.
ORA-02285: duplicate START WITH specifications
Cause: Self-evident.
Action: Remove the duplicate specification.
ORA-02286: no options specified for ALTER SEQUENCE
Cause: Self-evident.
Action: The statement is meaningless without any options.
ORA-02287: sequence number not allowed here
Cause: The specified sequence number (CURRVAL or NEXTVAL) is inappropriate here in the statement.
Action: Remove the sequence number.
ORA-02288: invalid OPEN mode
Cause: A token other than RESETLOGS appears following ALTER DATABASE <name> OPEN.
Action: Either nothing or RESETLOGS should be placed following OPEN.
ORA-02289: sequence does not exist
Cause: The specified sequence does not exist, or the user does not have the required privilege to perform this operation.
Action: Make sure the sequence name is correct, and that you have the right to perform the desired operation on this sequence.
ORA-02290: check constraint (string.string) violated
Cause: The values being inserted do not satisfy the named check constraint.
Action: do not insert values that violate the constraint.
ORA-02291: integrity constraint (string.string) violated – parent key not found
Cause: A foreign key value has no matching primary key value.
Action: Delete the foreign key or add a matching primary key.
ORA-02292: integrity constraint (string.string) violated – child record found
Cause: attempted to delete a parent key value that had a foreign key dependency.
Action: delete dependencies first then parent or disable constraint.
ORA-02293: cannot validate (string.string) – check constraint violated
Cause: an alter table operation tried to validate a check constraint to a populated table that had nocomplying values.
Action: Obvious
ORA-02294: cannot enable (string.string) – constraint changed during validation
Cause: While one DDL statement was attempting to enable this constraint, another DDL changed this same constraint.
Action: Try again, with only one DDL changing the constraint this time.
ORA-02295: found more than one enable/disable clause for constraint
Cause: a create or alter table specified more than one enable and/or disable clause for a given constraint.
Action: only one enable or disable may be specified for a given constraint.
ORA-02296: cannot enable (string.string) – null values found
Cause: an alter table enable constraint failed because the table contains values that do not satisfy the constraint.
Action: Obvious
ORA-02297: cannot disable constraint (string.string) – dependencies exist
Cause: an alter table disable constraint failed becuase the table has foriegn keys that are dpendent on this constraint.
Action: Either disable the foreign key constraints or use disable cascade
ORA-02298: cannot validate (string.string) – parent keys not found
Cause: an alter table validating constraint failed because the table has orphaned child records.
Action: Obvious
ORA-02299: cannot validate (string.string) – duplicate keys found
Cause: an alter table validating constraint failed because the table has duplicate key values.
Action: Obvious
ORA-02300: invalid value for OIDGENERATORS
Cause: A number was not specified for the value of OIDGENERATORS.
Action: Specify a number for OIDGENERATORS.

Leave a Reply

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

Time limit is exhausted. Please reload CAPTCHA.