- 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