• Oracle® Database 11g Error Codes ORA-02140 to ORA-04099

• ORA-02140: invalid tablespace name
• ORA-02141: invalid OFFLINE option
• ORA-02142: missing or invalid ALTER TABLESPACE option
• ORA-02143: invalid STORAGE option
• ORA-02144: no option specified for ALTER CLUSTER
• ORA-02145: missing STORAGE option
• ORA-02146: SHARED specified multiple times
• ORA-02147: conflicting SHARED/EXCLUSIVE options
• ORA-02148: EXCLUSIVE specified multiple times
• ORA-02149: Specified partition does not exist
• ORA-02150: invalid new tablespace name
• ORA-02151: invalid tablespace name: [string]
• ORA-02152: Invalid ALTER TABLESPACE ... RENAME option
• ORA-02153: invalid VALUES password [string]
• ORA-02154: a tablespace with the name '[string]' is found
• ORA-02155: invalid DEFAULT tablespace identifier
• ORA-02156: invalid TEMPORARY tablespace identifier
• ORA-02157: no options specified for ALTER USER
• ORA-02158: invalid CREATE INDEX option
• ORA-02159: installed DLM does not support releasable locking mode
• ORA-02160: index-organized table can not contain columns of type LONG
• ORA-02161: invalid value for MAXLOGFILES
• ORA-02162: invalid value for MAXDATAFILES
• ORA-02163: invalid value for FREELIST GROUPS
• ORA-02164: DATAFILE clause specified more than once
• ORA-02165: invalid option for CREATE DATABASE
• ORA-02166: ARCHIVELOG and NOARCHIVELOG specified
• ORA-02167: LOGFILE clause specified more than once
• ORA-02168: invalid value for FREELISTS
• ORA-02169: FREELISTS storage option not allowed
• ORA-02170: FREELIST GROUPS storage option not allowed
• ORA-02171: invalid value for MAXLOGHISTORY
• ORA-02172: The PUBLIC keyword is not appropriate for a disable thread
• ORA-02173: invalid option for DROP TABLESPACE
• ORA-02174: Missing required thread number
• ORA-02175: invalid rollback segment name
• ORA-02176: invalid option for CREATE ROLLBACK SEGMENT
• ORA-02177: Missing required group number
• ORA-02178: correct syntax is: SET TRANSACTION READ { ONLY | WRITE }
• ORA-02179: valid options: ISOLATION LEVEL { SERIALIZABLE | READ COMMITTED }
• ORA-02180: invalid option for CREATE TABLESPACE
• ORA-02181: invalid option to ROLLBACK WORK
• ORA-02182: savepoint name expected
• ORA-02183: valid options: ISOLATION_LEVEL { SERIALIZABLE | READ COMMITTED }
• ORA-02184: resource quotas are not allowed in REVOKE
• ORA-02185: a token other than WORK follows COMMIT
• ORA-02186: tablespace resource privilege may not appear with other privileges
• ORA-02187: invalid quota specification
• ORA-02188: Cannot enable instance publicly
• ORA-02189: ON required
• ORA-02190: keyword TABLES expected
• ORA-02191: correct syntax is: SET TRANSACTION USE ROLLBACK SEGMENT
• ORA-02192: PCTINCREASE not allowed for rollback segment storage clauses
• ORA-02194: event specification syntax error string (minor error string) near '[string]'
• ORA-02195: Attempt to create [string] object in a [string] tablespace
• ORA-02196: PERMANENT/TEMPORARY option already specified
• ORA-02197: file list already specified
• ORA-02198: ONLINE/OFFLINE option already specified
• ORA-02199: missing DATAFILE/TEMPFILE clause
• 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
• ORA-02300: invalid value for OIDGENERATORS
• ORA-02301: maximum number of OIDGENERATORS is 255
• ORA-02302: invalid or missing type name
• ORA-02303: cannot drop or replace a type with type or table dependents
• ORA-02304: invalid object identifier literal
• ORA-02305: only EXECUTE, DEBUG, and UNDER privileges are valid for types
• ORA-02306: cannot create a type that already has valid dependent(s)
• ORA-02307: cannot alter with REPLACE option a type that is not valid
• ORA-02308: invalid option [string] for object type column
• ORA-02309: atomic NULL violation
• ORA-02310: exceeded maximum number of allowable columns in table
• ORA-02311: cannot alter with COMPILE option a valid type with type or table dependents
• ORA-02313: object type contains non-queryable type [string] attribute
• ORA-02314: illegal use of type constructor
• ORA-02315: incorrect number of arguments for default constructor
• ORA-02320: failure in creating storage table for nested table column [string]
• ORA-02322: failure in accessing storage table of the nested table column
• ORA-02324: more than one column in the SELECT list of THE subquery
• ORA-02327: cannot create index on expression with datatype [string]
• ORA-02329: column of datatype [string] cannot be unique or a primary key
• ORA-02330: datatype specification not allowed
• ORA-02331: cannot create constraint on column of datatype [string]
• ORA-02332: cannot create index on attributes of this column
• ORA-02333: cannot create constraints on attributes of this column
• ORA-02334: cannot infer type for column
• ORA-02335: invalid datatype for cluster column
• ORA-02336: column attribute cannot be accessed
• ORA-02337: not an object type column
• ORA-02338: missing or invalid column constraint specification
• ORA-02339: invalid column specification
• ORA-02340: invalid column specification
• ORA-02342: replacement type has compilation errors
• ORA-02344: cannot revoke execute on a type with table dependents
• ORA-02345: cannot create a view with column based on CURSOR operator
• ORA-02347: cannot grant privileges on columns of an object table
• ORA-02348: cannot create VARRAY column with embedded LOB
• ORA-02349: invalid user-defined type - type is incomplete
• ORA-02351: internal error: [string]
• ORA-02352: error setting an OCI attribute: [string]
• ORA-02353: error fetching an OCI attribute: [string]
• ORA-02354: error in exporting/importing data [string]
• ORA-02355: error opening file: [string]
• ORA-02356: The database is out of space. The load cannot continue
• ORA-02357: header in file [string] may not contain correct information
• ORA-02358: error in exporting or importing data
• ORA-02359: database version in file [string] is not valid
• ORA-02360: fatal error during data export/import initialization
• ORA-02361: error while attempting to allocate number bytes of memory
• ORA-02362: error closing file: [string]
• ORA-02363: error reading from file: [string]
• ORA-02364: error writing to file: [string]
• ORA-02365: error seeking in file: [string]
• ORA-02366: The following index(es) on table [string] were processed:
• ORA-02367: read ended but had expected more data from file [string]
• ORA-02368: the following file is not valid for this load operation
• ORA-02369: internal number in header in file [string] is not valid
• ORA-02370: internal metadata in file [string] is not valid
• ORA-02371: Loader must be at least version [string].[string].[string].[string].[string] for direct path
• ORA-02372: data for row: [string]
• ORA-02373: Error parsing insert statement for table [string].
• ORA-02374: conversion error loading table [string].[string]
• ORA-02375: conversion error loading table [string].[string] partition [string]
• ORA-02376: invalid or redundant resource
• ORA-02377: invalid resource limit
• ORA-02379: profile [string] already exists
• ORA-02380: profile [string] does not exist
• ORA-02381: cannot drop PUBLIC_DEFAULT profile
• ORA-02383: illegal cost factor
• ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit
• ORA-02396: exceeded maximum idle time, please connect again
• ORA-02397: exceeded PRIVATE_SGA limit, you are being logged off
• ORA-02398: exceeded procedure space usage
• ORA-02399: exceeded maximum connect time, you are being logged off
• ORA-02400: explain plan output buffer size limit exceeded
• ORA-02401: cannot EXPLAIN view owned by another user
• ORA-02402: PLAN_TABLE not found
• ORA-02403: plan table does not have correct format
• ORA-02404: specified plan table not found
• ORA-02405: invalid sql plan object provided
• ORA-02420: missing schema authorization clause
• ORA-02421: missing or invalid schema authorization identifier
• ORA-02422: missing or invalid schema element
• ORA-02423: schema name does not match schema authorization identifier
• ORA-02424: potential circular view references or unknown referenced tables
• ORA-02425: create table failed
• ORA-02426: privilege grant failed
• ORA-02427: create view failed
• ORA-02428: could not add foreign key reference
• ORA-02429: cannot drop index used for enforcement of unique/primary key
• ORA-02430: cannot enable constraint ([string]) - no such constraint
• ORA-02431: cannot disable constraint ([string]) - no such constraint
• ORA-02432: cannot enable primary key - primary key not defined for table
• ORA-02433: cannot disable primary key - primary key not defined for table
• ORA-02434: cannot enable unique([string]) - unique key not defined for table
• ORA-02435: cannot disable unique([string]) - unique key not defined for table
• ORA-02436: date or system variable wrongly specified in CHECK constraint