home

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

  • 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

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners

Oracle: Registered trademark of Oracle