ORA-02200 TO ORA-02299

ORA-02200 TO ORA-02299

ORA-02200: WITH GRANT OPTION not allowed for PUBLIC
ORA-02201: sequence not allowed here
ORA-02202: no more tables permitted in this cluster
ORA-02203: INITIAL storage options not allowed
ORA-02204: ALTER, INDEX and EXECUTE not allowed for views
ORA-02205: only SELECT and ALTER privileges are valid for sequences
ORA-02206: duplicate INITRANS option specification
ORA-02207: invalid INITRANS option value
ORA-02208: duplicate MAXTRANS option specification
ORA-02209: invalid MAXTRANS option value
ORA-02210: no options specified for ALTER TABLE
ORA-02211: invalid value for PCTFREE or PCTUSED
ORA-02212: duplicate PCTFREE option specification
ORA-02213: duplicate PCTUSED option specification
ORA-02214: duplicate BACKUP option specification
ORA-02215: duplicate tablespace name clause
ORA-02216: tablespace name expected
ORA-02217: duplicate storage option specification
ORA-02218: invalid INITIAL storage option value
ORA-02219: invalid NEXT storage option value
ORA-02220: invalid MINEXTENTS storage option value
ORA-02221: invalid MAXEXTENTS storage option value
ORA-02222: invalid PCTINCREASE storage option value
ORA-02223: invalid OPTIMAL storage option value
ORA-02224: EXECUTE privilege not allowed for tables
ORA-02225: only EXECUTE and DEBUG privileges are valid for procedures
ORA-02226: invalid MAXEXTENTS value (max allowed: string)
ORA-02227: invalid cluster name
ORA-02228: duplicate SIZE specification
ORA-02229: invalid SIZE option value
ORA-02230: invalid ALTER CLUSTER option
ORA-02231: missing or invalid option to ALTER DATABASE
ORA-02232: invalid MOUNT mode
ORA-02233: invalid CLOSE mode
ORA-02234: changes to this table are already logged
ORA-02235: this table logs changes to another table already
ORA-02236: invalid file name
ORA-02237: invalid file size
ORA-02238: filename lists have different numbers of files
ORA-02239: there are objects which reference this sequence
ORA-02240: invalid value for OBJNO or TABNO
ORA-02241: must of form EXTENTS (FILE BLOCK SIZE , …)
ORA-02242: no options specified for ALTER INDEX
ORA-02243: invalid ALTER INDEX or ALTER MATERIALIZED VIEW option
ORA-02244: invalid ALTER ROLLBACK SEGMENT option
ORA-02245: invalid ROLLBACK SEGMENT name
ORA-02246: missing EVENTS text
ORA-02247: no option specified for ALTER SESSION
ORA-02248: invalid option for ALTER SESSION
ORA-02249: missing or invalid value for MAXLOGMEMBERS
ORA-02250: missing or invalid constraint name
ORA-02251: subquery not allowed here
ORA-02252: check constraint condition not properly ended
ORA-02253: constraint specification not allowed here
ORA-02254: DEFAULT not allowed here
ORA-02255: obsolete 7.1.5
ORA-02256: number of referencing columns must match referenced columns
ORA-02257: maximum number of columns exceeded
ORA-02258: duplicate or conflicting NULL and/or NOT NULL specifications
ORA-02259: duplicate UNIQUE/PRIMARY KEY specifications
ORA-02260: table can have only one primary key
ORA-02261: such unique or primary key already exists in the table
ORA-02262: ORA-string occurs while type-checking column default value expression
ORA-02263: need to specify the datatype for this column
ORA-02264: name already used by an existing constraint
ORA-02265: cannot derive the datatype of the referencing column
ORA-02266: unique/primary keys in table referenced by enabled foreign keys
ORA-02267: column type incompatible with referenced column type
ORA-02268: referenced table does not have a primary key
ORA-02269: key column cannot be of LONG datatype
ORA-02270: no matching unique or primary key for this column-list
ORA-02271: table does not have such constraint
ORA-02272: constrained column cannot be of LONG datatype
ORA-02273: this unique/primary key is referenced by some foreign keys
ORA-02274: duplicate referential constraint specifications
ORA-02275: such a referential constraint already exists in the table
ORA-02276: default value type incompatible with column type
ORA-02277: invalid sequence name
ORA-02278: duplicate or conflicting MAXVALUE/NOMAXVALUE specifications
ORA-02279: duplicate or conflicting MINVALUE/NOMINVALUE specifications
ORA-02280: duplicate or conflicting CYCLE/NOCYCLE specifications
ORA-02281: duplicate or conflicting CACHE/NOCACHE specifications
ORA-02282: duplicate or conflicting ORDER/NOORDER specifications
ORA-02283: cannot alter starting sequence number
ORA-02284: duplicate INCREMENT BY specifications
ORA-02285: duplicate START WITH specifications
ORA-02286: no options specified for ALTER SEQUENCE
ORA-02287: sequence number not allowed here
ORA-02288: invalid OPEN mode
ORA-02289: sequence does not exist
ORA-02290: check constraint (string.string) violated
ORA-02291: integrity constraint (string.string) violated – parent key not found
ORA-02292: integrity constraint (string.string) violated – child record found
ORA-02293: cannot validate (string.string) – check constraint violated
ORA-02294: cannot enable (string.string) – constraint changed during validation
ORA-02295: found more than one enable/disable clause for constraint
ORA-02296: cannot enable (string.string) – null values found
ORA-02297: cannot disable constraint (string.string) – dependencies exist
ORA-02298: cannot validate (string.string) – parent keys not found
ORA-02299: cannot validate (string.string) – duplicate keys found

Back to ALL ORA-CODE TRACKS
Back to ALL ORA-CODE LIST

Translate »