back
Oracle® Database 11g / 12c / 18c error codes ORA-02140-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