61 ORA-02100 to ORA-04099

ORA-02100: PCC: out of memory (i.e., could not allocate)
ORA-02101: PCC: inconsistent cursor cache (uce/cuc mismatch)
ORA-02102: PCC: inconsistent cursor cache (no cuc entry for this uce)
ORA-02103: PCC: inconsistent cursor cache (out-of-range cuc ref)
ORA-02104: PCC: inconsistent host cache (no cuc available)
ORA-02105: PCC: inconsistent cursor cache (no cuc entry in cache)
ORA-02106: PCC: inconsistent cursor cache (OraCursor nr is bad)
ORA-02107: PCC: this pgm too old for run-time library: please re-PCC it
ORA-02108: PCC: invalid descriptor passed to run-time library
ORA-02109: PCC: inconsistent host cache (out-of-range sit ref)
ORA-02110: PCC: inconsistent host cache (invalid sqi type)
ORA-02111: PCC: heap consistency error
ORA-02112: PCC: SELECT..INTO returns too many rows
ORA-02140: invalid tablespace name

Cause: An identifier does not follow ALTER TABLESPACE.

Action: Specify a tablespace name following ALTER TABLESPACE.

ORA-02141: invalid OFFLINE option

Cause: An option other than NORMAL or IMMEDIATE follows OFFLINE.

Action: The user must either specify no option following OFFLINE or one of the options NORMAL or IMMEDIATE.

ORA-02142: missing or invalid ALTER TABLESPACE option

Cause: A valid option was not present.

Action: Use one of the valid options: add, rename, default, online, offline, read only, read write, begin, end, no, force, retention guarantee and retention noguarantee.

ORA-02143: invalid STORAGE option

Cause: An option other than INITIAL, NEXT, MINEXTENTS, MAXEXTENTS, or PCTINCREASE was specified in the STORAGE clause.

Action: Specify only valid options.

ORA-02144: no option specified for ALTER CLUSTER

Cause: No ALTER CLUSTER options are specified.

Action: Specify one or more of the following options: pctfree, pctused, size, storage.

ORA-02145: missing STORAGE option

Cause: No STORAGE options were specified following STORAGE (

Action: Specify one or more STORAGE option between the parentheses.

ORA-02146: SHARED specified multiple times

Cause: The SHARED option was specified in a CREATE DATABASE statement multiple times.

Action: Only specify the SHARED option once.

ORA-02147: conflicting SHARED/EXCLUSIVE options

Cause: Both the SHARED and EXCLUSIVE options were specified in a CREATE DATABASE statement.

Action: Specify SHARED or EXCLUSIVE, but not both.

ORA-02148: EXCLUSIVE specified multiple times

Cause: The EXCLUSIVE option was specified in a CREATE DATABASE statement multiple times.

Action: Only specify the EXCLUSIVE option once.

ORA-02149: Specified partition does not exist

Cause: Partition not found for the object.

Action: Retry with correct partition name.

ORA-02150: invalid new tablespace name

Cause: The new tablespace name specified in ALTER TABLESPACE RENAME TO statement was invalid.

Action: Retry with a valid new tablespace name.

ORA-02151: invalid tablespace name: string

Cause: Oracle cannot create a tablespace whose name starts with '_$deleted$'.

Action: Try a different tablespace name.

ORA-02152: Invalid ALTER TABLESPACE ... RENAME option

Cause: An option other than DATAFILE or TO follows by ALTER TABLESPACE ... RENAME.

Action: The user must specify either DATAFILE or TO following ALTER TABLESPACE ... RENAME.

ORA-02153: invalid VALUES password string

Cause: An encoded password string does not follow the VALUES clause.

Action: Place a proper encoded password string after the VALUES clause.

ORA-02154: a tablespace with the name 'string' is found

Cause: An attempt to rename a tablespace to a new name failed because the new name is already used by some other tablespace.

Action: Retry with a different new name.

ORA-02155: invalid DEFAULT tablespace identifier

Cause: An identifier does not follow DEFAULT TABLESPACE.

Action: Place a tablespace name after DEFAULT TABLESPACE.

ORA-02156: invalid TEMPORARY tablespace identifier

Cause: An identifier does not follow TEMPORARY TABLESPACE.

Action: Place a tablespace name after TEMPORARY TABLESPACE.

ORA-02157: no options specified for ALTER USER

Cause: No options were specified.

Action: Specify at least one ALTER USER option.

ORA-02158: invalid CREATE INDEX option

Cause: An option other than COMPRESS, NOCOMPRESS, PCTFREE, INITRANS, MAXTRANS, STORAGE, TABLESPACE, PARALLEL, NOPARALLEL, RECOVERABLE, UNRECOVERABLE, LOGGING, NOLOGGING, LOCAL, or GLOBAL was specified.

Action: Choose one of the valid CREATE INDEX options.

ORA-02159: installed DLM does not support releasable locking mode

Cause: The parameter file specified gc_* parameters that allow locks to be release by the LCK process when not in use. This mode requires additional support from the DLM that is not available.

Action: Specify configuration parameters that do not require the additional function.

ORA-02160: index-organized table can not contain columns of type LONG

Cause: A column of type LONG defined for index-organized table.

Action: Do not use columns of type LONG in index-organized tables.

ORA-02161: invalid value for MAXLOGFILES

Cause: A number does not follow MAXLOGFILES.

Action: Specify a number after MAXLOGFILES.

ORA-02162: invalid value for MAXDATAFILES

Cause: A number does not follow MAXDATAFILES.

Action: Specify a number after MAXDATAFILES.

ORA-02163: invalid value for FREELIST GROUPS

Cause: A number does not follow FREELIST GROUPS.

Action: Specify a number after FREELIST GROUPS.

ORA-02164: DATAFILE clause specified more than once

Cause: The CREATE DATABASE command contains more than one DATAFILE clause.

Action: Specify at most one DATAFILE clause.

ORA-02165: invalid option for CREATE DATABASE

Cause: An invalid CREATE DATABASE option is present.

Action: Specify only valid CREATE DATABASE options.

ORA-02166: ARCHIVELOG and NOARCHIVELOG specified

Cause: Both ARCHIVELOG and NOARCHIVELOG are specified in a CREATE DATABASE statement.

Action: Specify at most one of these two options.

ORA-02167: LOGFILE clause specified more than once

Cause: The CREATE DATABASE command contains more than one LOGFILE clause.

Action: Specify at most one LOGFILE clause.

ORA-02168: invalid value for FREELISTS

Cause: A number does not follow FREELISTS

Action: Specify a number after FREELISTS

ORA-02169: FREELISTS storage option not allowed

Cause: The user attempted to specify the FREELISTS storage option. This option may only be specified during create table or create index.

Action: Remove these options and retry the statement.

ORA-02170: FREELIST GROUPS storage option not allowed

Cause: The user attempted to specify the FREELIST GROUPS storage option. This option may only be specified during create table and when allow_freelist_groups INIT.ORA is specified.

Action: Remove this option and retry the statement or set the allow_freelist_groups INIT.ORA parameter.

ORA-02171: invalid value for MAXLOGHISTORY

Cause: A number does not follow MAXLOGHISTORY

Action: Specify a number after MAXLOGHISTORY

ORA-02172: The PUBLIC keyword is not appropriate for a disable thread

Cause: The PUBLIC keyword was specified for a disable.

Action: Remove the keyword and resubmit.

ORA-02173: invalid option for DROP TABLESPACE

Cause: Either a token other than INCLUDING was found following the tablespace name or some text was found following INCLUDING CONTENTS.

Action: Place nothing or only INCLUDING CONTENTS after the tablespace name.

ORA-02174: Missing required thread number

Cause: Must specify thread number after THREAD keyword

Action: n/a

ORA-02175: invalid rollback segment name

Cause: In the CREATE or DROP ROLLBACK SEGMENT statements, an identifier was not found following ROLLBACK SEGMENT.

Action: Place the segment name following ROLLBACK SEGMENT.

ORA-02176: invalid option for CREATE ROLLBACK SEGMENT

Cause: An invalid option was specified in a CREATE ROLLBACK SEGMENT statement.

Action: Specify one of the valid options: TABLESPACE and STORAGE.

ORA-02177: Missing required group number

Cause: Must specify group number after GROUP keyword

Action: n/a

ORA-02178: correct syntax is: SET TRANSACTION READ { ONLY | WRITE }

Cause: There is a syntax error in the user's statement.

Action: Correct the syntax as indicated.

ORA-02179: valid options: ISOLATION LEVEL { SERIALIZABLE | READ COMMITTED }

Cause: There is a syntax error in the user's statement.

Action: Correct the syntax as indicated.

ORA-02180: invalid option for CREATE TABLESPACE

Cause: An invalid option appeared.

Action: Specify one of the valid options: DATAFILE, DEFAULT STORAGE, ONLINE, OFFLINE, FORCE, RETENTION.

ORA-02181: invalid option to ROLLBACK WORK

Cause: A token other than TO follows ROLLBACK [WORK].

Action: Place nothing or TO SAVEPOINT name after ROLLBACK [WORK].

ORA-02182: savepoint name expected

Cause: An identifier does not follow ROLLBACK [WORK] TO [SAVEPOINT].

Action: Place a savepoint name following TO [SAVEPOINT].

ORA-02183: valid options: ISOLATION_LEVEL { SERIALIZABLE | READ COMMITTED }

Cause: There is a syntax error in the user's statement.

Action: Correct the syntax as indicated.

ORA-02184: resource quotas are not allowed in REVOKE

Cause: In a revoke statement, a resource quota was specified.

Action: Specify resource privilege without the quota.

ORA-02185: a token other than WORK follows COMMIT

Cause: A token other than WORK follows COMMIT.

Action: Place either nothing or WORK after COMMIT.

ORA-02186: tablespace resource privilege may not appear with other privileges

Cause: An attempt was made to grant or revoke a resource quota in the same statement in which other privileges are granted or revoked.

Action: Use a separate grant or revoke statement for the resource quota privilege.

ORA-02187: invalid quota specification

Cause: In a grant or revoke statement, the user attempted to grant a tablespace quota above the upper limit.

Action: Grant a smaller tablespace quota.

ORA-02188: Cannot enable instance publicly

Cause: An attempt was made to publicly enable a thread associated with an instance.

Action: Leave out the PUBLIC keyword.

ORA-02189: ON tablespace required

Cause: In a grant or revoke statement, the user specified a tablespace quota but did not follow it with the ON tablespace clause.

Action: Specify the tablespace on which the quota is to be applied with the ON tablespace clause.

ORA-02190: keyword TABLES expected

Cause: The keyword TABLES is expected following DROP CLUSTER name INCLUDING.

Action: Place TABLES after INCLUDING.

ORA-02191: correct syntax is: SET TRANSACTION USE ROLLBACK SEGMENT rbs

Cause: There is a syntax error in the user's statement.

Action: Correct the syntax as indicated.

ORA-02192: PCTINCREASE not allowed for rollback segment storage clauses

Cause: pctincrease was specified in a create or alter rollback segment

Action: reissue statement without the pctincrease clause

ORA-02194: event specification syntax error string (minor error string) near 'string'

Cause: There is a syntax error in an event specification.

Action: Fix the error.

ORA-02195: Attempt to create string object in a string tablespace

Cause: The object type is inconsistent with a tablespace contents.

Action: Create an object in a different tablespace, or change the user defaults.

ORA-02196: PERMANENT/TEMPORARY option already specified

Cause: In CREATE TABLESPACE, the PERMANENT and/or TEMPORARY options were specified more than once.

Action: n/a

ORA-02197: file list already specified

Cause: In CREATE TABLESPACE, more than one DATAFILE/TEMPFILE clause was specified.

Action: Merge the DATAFILE/TEMPFILE clauses into a single clause.

ORA-02198: ONLINE/OFFLINE option already specified

Cause: In CREATE TABLESPACE, the ONLINE and/or OFFLINE options were specified more than once.

Action: Specify at most one of ONLINE or OFFLINE.

ORA-02199: missing DATAFILE/TEMPFILE clause

Cause: A CREATE TABLESPACE statement has no DATAFILE/TEMPFILE clause.

Action: Specify a DATAFILE/TEMPFILE clause.

ORA-02200: WITH GRANT OPTION not allowed for PUBLIC

Cause: An attempt was made to GRANT to PUBLIC WITH GRANT OPTION.

Action: Remove the WITH GRANT OPTION clause.

ORA-02201: sequence not allowed here

Cause: An attempt was made to reference a sequence in a from-list.

Action: A sequence can only be referenced in a select-list.

ORA-02202: no more tables permitted in this cluster

Cause: An attempt was made to create a table in a cluster which already contains 32 tables.

Action: Up to 32 tables may be stored per cluster.

ORA-02203: INITIAL storage options not allowed

Cause: The user attempted to alter the INITIAL storage option of a table, cluster, index, or rollback segment. These options may only be specified when the object is created.

Action: Remove these options and retry the statement.

ORA-02204: ALTER, INDEX and EXECUTE not allowed for views

Cause: An attempt was made to grant or revoke an invalid privilege on a view.

Action: Do not attempt to grant or revoke any of ALTER, INDEX, or EXECUTE privileges on views.

ORA-02205: only SELECT and ALTER privileges are valid for sequences

Cause: An attempt was made to grant or revoke an invalid privilege on a sequence.

Action: Do not attempt to grant or revoke DELETE, INDEX, INSERT, UPDATE, REFERENCES or EXECUTE privilege on sequences.

ORA-02206: duplicate INITRANS option specification

Cause: INITRANS is specified more than once.

Action: Specify INITRANS at most once.

ORA-02207: invalid INITRANS option value

Cause: The INITRANS value is not an integer between 1 and 255 and less than or equal to the MAXTRANS value.

Action: Choose a valid INITRANS value.

ORA-02208: duplicate MAXTRANS option specification

Cause: MAXTRANS is specified more than once.

Action: Specify MAXTRANS at most once.

ORA-02209: invalid MAXTRANS option value

Cause: The MAXTRANS value is not an integer between 1 and 255 and greater than or equal to the INITRANS value.

Action: Choose a valid MAXTRANS value.

ORA-02210: no options specified for ALTER TABLE

Cause: No ALTER TABLE option was specified.

Action: Specify at least one alter table option.

ORA-02211: invalid value for PCTFREE or PCTUSED

Cause: The specified value for PCTFREE or PCTUSED is not an integer between 0 and 100.

Action: Choose an appropriate value for the option.

ORA-02212: duplicate PCTFREE option specification

Cause: PCTFREE option specified more than once.

Action: Specify PCTFREE at most once.

ORA-02213: duplicate PCTUSED option specification

Cause: PCTUSED option specified more than once.

Action: Specify PCTUSED at most once.

ORA-02214: duplicate BACKUP option specification

Cause: The BACKUP option to ALTER TABLE is specified more than once.

Action: Specify the option at most once.

ORA-02215: duplicate tablespace name clause

Cause: There is more than one TABLESPACE clause in the CREATE TABLE, CREATE INDEX, or CREATE ROLLBACK SEGMENT statement.

Action: Specify at most one TABLESPACE clause.

ORA-02216: tablespace name expected

Cause: A tablespace name was not present where required by the syntax for the failing statement.

Action: Specify a tablespace name where required by the syntax.

ORA-02217: duplicate storage option specification

Cause: A storage option (INIITAL, NEXT, MINEXTENTS, MAXEXTENTS, PCTINCREASE) is specified more than once.

Action: Specify all storage options at most once.

ORA-02218: invalid INITIAL storage option value

Cause: The specified value must be an integer.

Action: Choose an appropriate integer value.

ORA-02219: invalid NEXT storage option value

Cause: The specified value must be an integer.

Action: Choose an appropriate integer value.

ORA-02220: invalid MINEXTENTS storage option value

Cause: The specified value must be a positive integer less than or equal to MAXEXTENTS.

Action: Specify an appropriate value.

ORA-02221: invalid MAXEXTENTS storage option value

Cause: The specified value must be a positive integer greater than or equal to MINEXTENTS.

Action: Specify an appropriate value.

ORA-02222: invalid PCTINCREASE storage option value

Cause: The specified value must be a positive integer.

Action: Specify an appropriate value.

ORA-02223: invalid OPTIMAL storage option value

Cause: The specified value must be an integer.

Action: Choose an appropriate integer value.

ORA-02224: EXECUTE privilege not allowed for tables

Cause: An attempt was made to grant or revoke an invalid privilege on a table.

Action: Do not attempt to grant or revoke EXECUTE privilege on tables.

ORA-02225: only EXECUTE and DEBUG privileges are valid for procedures

Cause: An attempt was made to grant or revoke an invalid privilege on a procedure, function or package.

Action: Do not attempt to grant or revoke any privilege besides EXECUTE or DEBUG on procedures, functions or packages.

ORA-02226: invalid MAXEXTENTS value (max allowed: string)

Cause: The MAXEXTENTS specified is too large for the database block size. This applies only to SYSTEM rollback segment.

Action: Specify a smaller value.

ORA-02227: invalid cluster name

Cause: A cluster name of the form [ identifier . ] identifier is expected but not present.

Action: Enter an appropriate cluster name.

ORA-02228: duplicate SIZE specification

Cause: The SIZE option is specified more than once.

Action: Specify the SIZE option at most once.

ORA-02229: invalid SIZE option value

Cause: The specified value must be an integer number of bytes.

Action: Specify an appropriate value.

ORA-02230: invalid ALTER CLUSTER option

Cause: An option other than PCTFREE, PCTUSED, INITRANS, MAXTRANS, STORAGE, or SIZE is specified in an ALTER CLUSTER statement.

Action: Specify only legal options.

ORA-02231: missing or invalid option to ALTER DATABASE

Cause: An option other than ADD, DROP, RENAME, ARCHIVELOG, NOARCHIVELOG, MOUNT, DISMOUNT, OPEN, or CLOSE is specified in the statement.

Action: Specify only legal options.

ORA-02232: invalid MOUNT mode

Cause: A mode other than SHARED or EXCLUSIVE follows the MOUNT keyword in an ALTER DATABASE statement.

Action: Specify either SHARED, EXCLUSIVE, or nothing following MOUNT.

ORA-02233: invalid CLOSE mode

Cause: A mode other than NORMAL or IMMEDIATE follows the CLOSE keyword in an ALTER DATABASE statement.

Action: Specify either NORMAL, IMMEDIATE, or nothing following CLOSE.

ORA-02234: changes to this table are already logged

Cause: the log table to be added is a duplicate of another

Action: Don't add this change log to the system; check that the replication product's system tables are consistent

ORA-02235: this table logs changes to another table already

Cause: the table to be altered is already a change log for another table

Action: Don't log changes to the specified base table to this table; check that the replication product's system tables are consistent

ORA-02236: invalid file name

Cause: A character string literal was not used in the filename list of a LOGFILE, DATAFILE, or RENAME clause.

Action: Use correct syntax.

ORA-02237: invalid file size

Cause: A non-integer value was specified in the SIZE or RESIZE clause.

Action: Use correct syntax.

ORA-02238: filename lists have different numbers of files

Cause: In a RENAME clause in ALTER DATABASE or TABLESPACE, the the number of existing filenames does not equal the number of new filenames.

Action: Make sure there is a new filename to correspond to each existing filename.

ORA-02239: there are objects which reference this sequence

Cause: the sequence to be dropped is still referenced

Action: Make sure the sequence name is correct, or drop the referencing constraint/object

ORA-02240: invalid value for OBJNO or TABNO

Cause: A number does not follow either OBJNO or TABNO.

Action: Specify a number after OBJNO or TABNO.

ORA-02241: must of form EXTENTS (FILE n BLOCK n SIZE n, ...)

Cause: bad extent storage clause

Action: respecify

ORA-02242: no options specified for ALTER INDEX

Cause: No options specified.

Action: Specify at least one of REBUILD, INITRANS, MAXTRANS, or STORAGE.

ORA-02243: invalid ALTER INDEX or ALTER MATERIALIZED VIEW option

Cause: An option other than INITRANS, MAXTRANS,or STORAGE is specified in an ALTER INDEX statement or in the USING INDEX clause of an ALTER MATERIALIZED VIEW statement.

Action: Specify only legal options.

ORA-02244: invalid ALTER ROLLBACK SEGMENT option

Cause: The STORAGE option is expected but not found.

Action: Specify the STORAGE option.

ORA-02245: invalid ROLLBACK SEGMENT name

Cause: An identifier was expected, but not found, following ALTER [PUBLIC] ROLLBACK SEGMENT.

Action: Place a rollback segment name following SEGMENT.

ORA-02246: missing EVENTS text

Cause: A character string literal was expected, but not found, following ALTER SESSION SET EVENTS.

Action: Place the string literal containing the events text after EVENTS.

ORA-02247: no option specified for ALTER SESSION

Cause: The option SET EVENTS was expected, but not found, following ALTER SESSION.

Action: Place the SET EVENTS option after ALTER SESSION.

ORA-02248: invalid option for ALTER SESSION

Cause: Obvious.

Action: see SQL Language Manual for legal options.

ORA-02249: missing or invalid value for MAXLOGMEMBERS

Cause: A valid number does not follow MAXLOGMEMBERS. The value specified must be between 1 and the port-specific maximum number of log file members.

Action: Specify a valid number after MAXLOGMEMBERS.

ORA-02250: missing or invalid constraint name

Cause: The constraint name is missing or invalid.

Action: Specify a valid identifier name for the constraint name.

ORA-02251: subquery not allowed here

Cause: Subquery is not allowed here in the statement.

Action: Remove the subquery from the statement.

ORA-02252: check constraint condition not properly ended

Cause: The specified search condition for the check constraint is not properly ended.

Action: End the condition properly.

ORA-02253: constraint specification not allowed here

Cause: Constraint specification is not allowed here in the statement.

Action: Remove the constraint specification from the statement.

ORA-02254: DEFAULT expression not allowed here

Cause: Default value expression is not allowed for the column here in the statement.

Action: Remove the default value expression from the statement.

ORA-02255: obsolete 7.1.5

Cause: Was that defaults must not conflict with not null constraints

Action: n/a

ORA-02256: number of referencing columns must match referenced columns

Cause: The number of columns in the foreign-key referencing list is not equal to the number of columns in the referenced list.

Action: Make sure that the referencing columns match the referenced columns.

ORA-02257: maximum number of columns exceeded

Cause: The number of columns in the key list exceeds the maximum number.

Action: Reduce the number columns in the list.

ORA-02258: duplicate or conflicting NULL and/or NOT NULL specifications

Cause: Self-evident.

Action: Remove the duplicate or conflicting specification.

ORA-02259: duplicate UNIQUE/PRIMARY KEY specifications

Cause: Self-evident.

Action: Remove the duplicate specification.

ORA-02260: table can have only one primary key

Cause: Self-evident.

Action: Remove the extra primary key.

ORA-02261: such unique or primary key already exists in the table

Cause: Self-evident.

Action: Remove the extra key.

ORA-02262: ORA-string occurs while type-checking column default value expression

Cause: New column datatype causes type-checking error for existing column default value expression.

Action: Remove the default value expression or don't alter the column datatype.

ORA-02263: need to specify the datatype for this column

Cause: The required datatype for the column is missing.

Action: Specify the required datatype.

ORA-02264: name already used by an existing constraint

Cause: The specified constraint name has to be unique.

Action: Specify a unique constraint name for the constraint.

ORA-02265: cannot derive the datatype of the referencing column

Cause: The datatype of the referenced column is not defined as yet.

Action: Make sure that the datatype of the referenced column is defined before referencing it.

ORA-02266: unique/primary keys in table referenced by enabled foreign keys

Cause: An attempt was made to truncate a table with unique or primary keys referenced by foreign keys enabled in another table. Other operations not allowed are dropping/truncating a partition of a partitioned table or an ALTER TABLE EXCHANGE PARTITION.

Action: Before performing the above operations the table, disable the foreign key constraints in other tables. You can see what constraints are referencing a table by issuing the following command: SELECT * FROM USER_CONSTRAINTS WHERE TABLE_NAME = "tabnam";

ORA-02267: column type incompatible with referenced column type

Cause: The datatype of the referencing column is incompatible with the

Action: Select a compatible datatype for the referencing column.

ORA-02268: referenced table does not have a primary key

Cause: The referenced table does not have a primary key.

Action: Specify explicitly the referenced table unique key.

ORA-02269: key column cannot be of LONG datatype

Cause: Self-evident.

Action: Change the datatype of the column, or remove the column from the key.

ORA-02270: no matching unique or primary key for this column-list

Cause: A REFERENCES clause in a CREATE/ALTER TABLE statement gives a column-list for which there is no matching unique or primary key constraint in the referenced table.

Action: Find the correct column names using the ALL_CONS_COLUMNS catalog view

ORA-02271: table does not have such constraint

Cause: Self-evident.

Action: Make sure the specified constraint name is correct.

ORA-02272: constrained column cannot be of LONG datatype

Cause: Self-evident.

Action: Change the datatype of the column, or remove the constraint on the column.

ORA-02273: this unique/primary key is referenced by some foreign keys

Cause: Self-evident.

Action: Remove all references to the key before the key is to be dropped.

ORA-02274: duplicate referential constraint specifications

Cause: Self-evident.

Action: Remove the duplicate specification.

ORA-02275: such a referential constraint already exists in the table

Cause: Self-evident.

Action: Remove the extra constraint.

ORA-02276: default value type incompatible with column type

Cause: The type of the evaluated default expression is incompatible with the datatype of the column.

Action: Change the type of the column, or modify the default expression.

ORA-02277: invalid sequence name

Cause: The specified sequence name is not a valid identifier name.

Action: Specify a valid identifier name for the sequence name.

ORA-02278: duplicate or conflicting MAXVALUE/NOMAXVALUE specifications

Cause: Self-evident.

Action: Remove the duplicate or conflicting specification.

ORA-02279: duplicate or conflicting MINVALUE/NOMINVALUE specifications

Cause: Self-evident.

Action: Remove the duplicate or conflicting specification.

ORA-02280: duplicate or conflicting CYCLE/NOCYCLE specifications

Cause: Self-evident.

Action: Remove the duplicate or conflicting specification.

ORA-02281: duplicate or conflicting CACHE/NOCACHE specifications

Cause: Self-evident.

Action: Remove the duplicate or conflicting specification.

ORA-02282: duplicate or conflicting ORDER/NOORDER specifications

Cause: Self-evident.

Action: Remove the duplicate or conflicting specification.

ORA-02283: cannot alter starting sequence number

Cause: Self-evident.

Action: Don't alter it.

ORA-02284: duplicate INCREMENT BY specifications

Cause: Self-evident.

Action: Remove the duplicate specification.

ORA-02285: duplicate START WITH specifications

Cause: Self-evident.

Action: Remove the duplicate specification.

ORA-02286: no options specified for ALTER SEQUENCE

Cause: Self-evident.

Action: The statement is meaningless without any options.

ORA-02287: sequence number not allowed here

Cause: The specified sequence number (CURRVAL or NEXTVAL) is inappropriate here in the statement.

Action: Remove the sequence number.

ORA-02288: invalid OPEN mode

Cause: A token other than RESETLOGS appears following ALTER DATABASE name OPEN.

Action: Either nothing or RESETLOGS should be placed following OPEN.

ORA-02289: sequence does not exist

Cause: The specified sequence does not exist, or the user does not have the required privilege to perform this operation.

Action: Make sure the sequence name is correct, and that you have the right to perform the desired operation on this sequence.

ORA-02290: check constraint (string.string) violated

Cause: The values being inserted do not satisfy the named check constraint.

Action: do not insert values that violate the constraint.

ORA-02291: integrity constraint (string.string) violated - parent key not found

Cause: A foreign key value has no matching primary key value.

Action: Delete the foreign key or add a matching primary key.

ORA-02292: integrity constraint (string.string) violated - child record found

Cause: attempted to delete a parent key value that had a foreign key dependency.

Action: delete dependencies first then parent or disable constraint.

ORA-02293: cannot validate (string.string) - check constraint violated

Cause: an alter table operation tried to validate a check constraint to a populated table that had nocomplying values.

Action: Obvious

ORA-02294: cannot enable (string.string) - constraint changed during validation

Cause: While one DDL statement was attempting to enable this constraint, another DDL changed this same constraint.

Action: Try again, with only one DDL changing the constraint this time.

ORA-02295: found more than one enable/disable clause for constraint

Cause: a create or alter table specified more than one enable and/or disable clause for a given constraint.

Action: only one enable or disable may be specified for a given constraint.

ORA-02296: cannot enable (string.string) - null values found

Cause: an alter table enable constraint failed because the table contains values that do not satisfy the constraint.

Action: Obvious

ORA-02297: cannot disable constraint (string.string) - dependencies exist

Cause: an alter table disable constraint failed becuase the table has foriegn keys that are dpendent on this constraint.

Action: Either disable the foreign key constraints or use disable cascade

ORA-02298: cannot validate (string.string) - parent keys not found

Cause: an alter table validating constraint failed because the table has orphaned child records.

Action: Obvious

ORA-02299: cannot validate (string.string) - duplicate keys found

Cause: an alter table validating constraint failed because the table has duplicate key values.

Action: Obvious

ORA-02300: invalid value for OIDGENERATORS

Cause: A number was not specified for the value of OIDGENERATORS.

Action: Specify a number for OIDGENERATORS.

ORA-02301: maximum number of OIDGENERATORS is 255

Cause: A number greater than 255 was specified for the value of OIDGENERATORS.

Action: Make sure the number specified for OIDGENERATORS does not exceed 255.

ORA-02302: invalid or missing type name

Cause: An invalid or missing type name was entered in a statement.

Action: Enter a valid type name in the statement and retry the operation.

ORA-02303: cannot drop or replace a type with type or table dependents

Cause: An attempt was made to drop or replace a type that has type or table dependents.

Action: For DROP TYPE, drop all type(s) and table(s) depending on the type and then retry the operation, or use the FORCE option. For CREATE TYPE, drop all type(s) and table(s) depending on the type and then retry the operation, or drop all table(s) depending on the type and retry with the FORCE option.

ORA-02304: invalid object identifier literal

Cause: An attempt was made to enter an object identifier literal for CREATE TYPE that is either: - not a string of 32 hexadecimal characters - an object identifier that already identifies an existing object - an object identifier different from the original object identifier already assigned to the type

Action: Do not specify the object identifier clause or specify a 32 hexadecimal-character object identifier literal that is unique or identical to the originally assigned object identifier. Then retry the operation.

ORA-02305: only EXECUTE, DEBUG, and UNDER privileges are valid for types

Cause: An attempt was made to GRANT or REVOKE an invalid privilege (not EXECUTE, DEBUG, or UNDER) on a type.

Action: GRANT or REVOKE only the EXECUTE, DEBUG, or UNDER privilege on types.

ORA-02306: cannot create a type that already has valid dependent(s)

Cause: An attempt was made to create a type that already has some valid dependent(s) (these dependents depend on the fact that the type does not exist).

Action: Drop the dependents first before creating the type, or do not create the type.

ORA-02307: cannot alter with REPLACE option a type that is not valid

Cause: An attempt was made to ALTER with REPLACE option a type that is not valid.

Action: Use the CREATE OR REPLACE TYPE command to modify the type.

ORA-02308: invalid option string for object type column

Cause: An attempt was made to specify an invalid option, such as PACKED or UNPACKED, for the object type column.

Action: Remove the invalid option from column specification and retry the operation.

ORA-02309: atomic NULL violation

Cause: An attempt was made to acess the attributes of a NULL object instance.

Action: Ensure that the object instance is non-NULL before accessing.

ORA-02310: exceeded maximum number of allowable columns in table

Cause: The attributes in the object type column exceeded the maximum number of columns allowed in a table.

Action: Specify fewer attributes for the object type and retry the operation.

ORA-02311: cannot alter with COMPILE option a valid type with type or table dependents

Cause: An attempt was made to ALTER with COMPILE option a type that is valid and has type or table dependents.

Action: No need to perform this operation.

ORA-02313: object type contains non-queryable type string attribute

Cause: The specified object type contains a nested attribute whose type is non-queryable.

Action: Use an object type with queryable attribute types.

ORA-02314: illegal use of type constructor

Cause: The statement contains an illegal use of a type constructor.

Action: Refer to the SQL Reference manual for the correct statement syntax.

ORA-02315: incorrect number of arguments for default constructor

Cause: The number of arguments specified for the default constructor doesn't match the number of attributes of the object type.

Action: Specify the correct number of arguments for the default constructor and retry the operation.

ORA-02320: failure in creating storage table for nested table column string

Cause: An error occurred while creating the storage table for the specified nested table column.

Action: See the messages that follow for more details. If the situation they describe can be corrected, do so; otherwise contact Oracle Support.

ORA-02322: failure in accessing storage table of the nested table column

Cause: An error occured while performing DML on the storage table of the nested table column.

Action: If the situation described in the following messages can be corrected, do so; otherwise contact Oracle Support.

ORA-02324: more than one column in the SELECT list of THE subquery

Cause: More than one column was selected in the THE subquery.

Action: Specify only one column in the SELECT list of the THE subquery and retry the operation.

ORA-02327: cannot create index on expression with datatype string

Cause: An attempt was made to create an index on a non-indexable expression.

Action: Change the column datatype or do not create the index on an expression whose datatype is one of VARRAY, nested table, object, LOB, or REF.

ORA-02329: column of datatype string cannot be unique or a primary key

Cause: An attempt was made to place a UNIQUE or a PRIMARY KEY constraint on a column of datatype VARRAY, nested table, object, LOB, FILE or REF.

Action: Change the column datatype or remove the constraint. Then retry the operation.

ORA-02330: datatype specification not allowed

Cause: An attempt was made to specify the data type in the column constraint specification of an object table.

Action: Remove data type specification and retry the operation.

ORA-02331: cannot create constraint on column of datatype string

Cause: An attempt was made to create a constraint on a column posessing a non-constrainable datatype -- VARRAY, nested table, object, LOB, FILE, or REF.

Action: Change the column datatype, or remove the constraint.

ORA-02332: cannot create index on attributes of this column

Cause: An attempt was made to create an index on an attributes of an object type column.

Action: Do not specify the index on the attribute.

ORA-02333: cannot create constraints on attributes of this column

Cause: An attempt was made to create a constraint on an attribute of an object type column.

Action: Remove the constraint or change the object type.

ORA-02334: cannot infer type for column

Cause: A datatype was not declared for this column (in the CREATE TABLE) and an attempt was made to create a constraint on an attribute of this column.

Action: Declare a datatype for the column.

ORA-02335: invalid datatype for cluster column

Cause: An attempt was made to declare a CLUSTER column of datatype object, REF, nested table, VARRAY, LOB, or FILE.

Action: Remove the CLUSTER column or change the datatype of the column.

ORA-02336: column attribute cannot be accessed

Cause: An attempt was made to extract an attribute of an object type column.

Action: Change the object type for the column and retry the operation.

ORA-02337: not an object type column

Cause: An attempt was made to use dotted notation on a non-ADT column; that is, "a.b.c" where "a" is not an object type.

Action: Either change the column type to an object type or do not perform this operation.

ORA-02338: missing or invalid column constraint specification

Cause: A column constraint was not specified.

Action: Remove the column specification or specify a column constraint. Then retry the operation.

ORA-02339: invalid column specification

Cause: An attempt was made to specify the PACKED or UNPACKED keyword for a non-object type column.

Action: Remove the PACKED or UNPACKED keyword in the column specification and retry the operation.

ORA-02340: invalid column specification

Cause: An attempt was made to specify an UNPACKED column within a packed table.

Action: Remove the UNPACKED keyword in the column specification.

ORA-02342: replacement type has compilation errors

Cause: The use of the ALTER...REPLACE statement on a valid type caused a compilation error.

Action: Use the ALTER...REPLACE statement to replace the type with a valid type which does not cause compilation errors.

ORA-02344: cannot revoke execute on a type with table dependents

Cause: An attempt was made to revoke execute on a type that has dependents.

Action: Drop all table(s) depending on the type, then retry the operation, or use the FORCE option.

ORA-02345: cannot create a view with column based on CURSOR operator

Cause: A CURSOR operator was used as one of the SELECT elements in the subquery of a CREATE VIEW or CREATE TABLE ... AS SELECT statement.

Action: Remove the CURSOR operator and replace it with the CAST operator.

ORA-02347: cannot grant privileges on columns of an object table

Cause: An attempt was made to grant privileges on the columns of an object table.

Action: n/a

ORA-02348: cannot create VARRAY column with embedded LOB

Cause: An attempt was made to create a column of a VARRAY type which has an embedded LOB attribute. The LOB could be an attribute of a subtype of the declared type of VARRAY's element.

Action: Remove offending attribute from type. If it is a subtype attribute then declare the VARRAY column NOT SUBSTITUTABLE.

ORA-02349: invalid user-defined type - type is incomplete

Cause: An attempt was made to use an incomplete type definition as a column or table datatype.

Action: Complete the type definition and retry the operation.

ORA-02351: internal error: string\n

Cause: An unexpected error condition was detected.

Action: Make a note of the error number and message and contact Oracle Support Services.

ORA-02352: error setting an OCI attribute: string\n

Cause: An OCI error has occurred.

Action: The table or column referenced may not be accessible. Contact Oracle Support Services if the problem cannot be resolved.

ORA-02353: error fetching an OCI attribute: string\n

Cause: An OCI error has occurred.

Action: The table or column referenced may not be accessible. Contact Oracle Support Services if the problem cannot be resolved.

ORA-02354: error in exporting/importing data\nstring

Cause: An error has occurred in a stream export or import operation. This message will be followed by another message giving more details about this error.

Action: See export/import documentation for an explanation of the second error message.

ORA-02355: error opening file: string\n

Cause: An attempt to open the specified file for data export/import failed.

Action: Review the error message. Resolve the problem and retry the the operation. Contact Oracle Support Services if the problem cannot be resolved.

ORA-02356: The database is out of space. The load cannot continue

Cause: The load was discontinued due to space exhaustion in the database.

Action: Add space for the specified table.

ORA-02357: header in file string may not contain correct information\n

Cause: The header may be corrupted.

Action: Contact Oracle Support Services.

ORA-02358: error in exporting or importing data\n

Cause: An error has occurred in a stream export or import operation.

Action: Contact Oracle Support Services.

ORA-02359: database version in file string is not valid\n

Cause: The specified file could not be used for this load because its database version was not compatible with the database version in the other files in the DUMPFILE clause.

Action: Verify all the files in the DUMPFILE clause are from the same unload operation.

ORA-02360: fatal error during data export/import initialization\n

Cause: An unexpected error occurred during initialization for data export/import.

Action: Contact Oracle Support Services.

ORA-02361: error while attempting to allocate number bytes of memory\n

Cause: An error occurred while trying to allocate memory. This is likely caused by insufficient memory.

Action: Reconnect to the instance and retry the operation.

ORA-02362: error closing file: string\n

Cause: An attempt to close the specified file for data export/import failed.

Action: Review the error message. Resolve the problem and retry the the operation. Contact Oracle Support Services if the problem cannot be resolved.

ORA-02363: error reading from file: string\n

Cause: An attempt to read from the specified file for data export/import failed.

Action: Review the error message. Resolve the problem and retry the the operation. Contact Oracle Support Services if the problem cannot be resolved.

ORA-02364: error writing to file: string\n

Cause: An attempt to write to the specified file for data export or import failed.

Action: Review the error message. Resolve the problem and retry the the operation. Contact Oracle Support Services if the problem cannot be resolved.

ORA-02365: error seeking in file: string\n

Cause: An attempt to seek to the specified position in file failed.

Action: Review the error message. Resolve the problem and retry the the operation. Contact Oracle Support Services if the problem cannot be resolved.

ORA-02366: The following index(es) on table string were processed:

Cause: The table had some indexes which were loaded if there were no errors.

Action: None

ORA-02367: read ended but had expected more data from file string\n

Cause: A truncated or incomplete file was used for the load operation.

Action: Verify unload operation completed successfully and that the files had not been accidentally truncated.

ORA-02368: the following file is not valid for this load operation\n

Cause: A file could not be used for this load. See the following message for more information.

Action: Verify all the files in the DUMPFILE clause are from the same unload operation and that the unload was successful.

ORA-02369: internal number in header in file string is not valid\n

Cause: The specified file could not be used for this load because the internal number in the header was not valid.

Action: If the dump files were transferred over, verify the transfer operation was done correctly.

ORA-02370: internal metadata in file string is not valid\n

Cause: The specified file could not be used for this load because the internal metadata stored in this file does not match the metadata stored in the first file piece set.

Action: Verify all the files in the DUMPFILE clause are from the same unload operation.

ORA-02371: Loader must be at least version string.string.string.string.string for direct path

Cause: The loader being used is incompatible with this version of the kernel.

Action: Upgrade your loader to at least the specified version or use the conventional path.

ORA-02372: data for row: string \n

Cause: A conversion error occurred while loading data into a table. The message shows values for the field in the row that had the conversion error.

Action: None. This is only an informational message.

ORA-02373: Error parsing insert statement for table string.

Cause: self-evident.

Action: Check the error given below this one.

ORA-02374: conversion error loading table string.string

Cause: A row could not be loaded into the table because there was a conversion error for one or more columns in a row.

Action: See the message that follows for more information about the row that could not be loaded. To avoid this error, make sure the definition of the table being imported matches the definition of the table being exported.

ORA-02375: conversion error loading table string.string partition string

Cause: A row could not be loaded into the table because there was a conversion error for one or more columns in a row.

Action: See the message that follows for more information about the row that could not be loaded. To avoid this error, make sure the definition of the table being imported matches the definition of the table being exported.

ORA-02376: invalid or redundant resource

Cause: a create, or alter profile command which names a resource not yet defined, or try to specify same resource twice.

Action: define resource first

ORA-02377: invalid resource limit

Cause: specifying limit of 0

Action: specify limit > 0

ORA-02378: duplicate resource name string
ORA-02379: profile string already exists

Cause: Try to create a profile which already exist

Action: n/a

ORA-02380: profile string does not exist

Cause: Try to assign a user to a non-existant profile

Action: n/a

ORA-02381: cannot drop PUBLIC_DEFAULT profile

Cause: Try to drop PUBLIC_DEFAULT profile

Action: n/a

ORA-02382: profile string has users assigned, cannot drop without CASCADE
ORA-02383: illegal cost factor

Cause: Negative or UNLIMITED cost for this resourc

Action: n/a

ORA-02390: exceeded COMPOSITE_LIMIT, you are being logged off
ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit

Cause: An attempt was made to exceed the maximum number of concurrent sessions allowed by the SESSION_PER_USER clause of the user profile.

Action: End one or more concurrent sessions or ask the database administrator to increase the SESSION_PER_USER limit of the user profile.

ORA-02392: exceeded session limit on CPU usage, you are being logged off
ORA-02393: exceeded call limit on CPU usage
ORA-02394: exceeded session limit on IO usage, you are being logged off
ORA-02395: exceeded call limit on IO usage
ORA-02396: exceeded maximum idle time, please connect again

Cause: as stated

Action: n/a

ORA-02397: exceeded PRIVATE_SGA limit, you are being logged off

Cause: Only when using TP monitor

Action: expand limit

ORA-02398: exceeded procedure space usage

Cause: Stored procedured used up too much space in SYSTEM Tablespace

Action: Use less stored procedure

ORA-02399: exceeded maximum connect time, you are being logged off

Cause: As stated

Action: n/a

ORA-02400: explain plan output buffer size limit exceeded

Cause: Internally this error is raised and caught to handle cases where the plan output exceeds te buffer size. The output is truncated in cases.

Action: This error should never be seen externally.

ORA-02401: cannot EXPLAIN view owned by another user

Cause: The view specified in the SQL statement belongs to another user and cannot be explained.

Action: Create a view with the same definition that belongs to current user.

ORA-02402: PLAN_TABLE not found

Cause: The table used by EXPLAIN to store row source information does not exist in the current schema.

Action: Create a plan table in the current schema or use the INTO clause of the statement to put the results of the explain command in an existing plan table.

ORA-02403: plan table does not have correct format

Cause: The explicit plan table does not have the appropriate field definitions.

Action: Redefine the plan table to have the appropriate field definitions.

ORA-02404: specified plan table not found

Cause: The specified plan table does cannot be found.

Action: Create the specified plan table or use an existing plan table.

ORA-02405: invalid sql plan object provided

Cause: The user provided a NULL, empty, or malformed object of type SQL_PLAN_TABLE_TYPE

Action: Provide a new, properly formed object to the function

ORA-02420: missing schema authorization clause

Cause: the AUTHORIZATION clause is missing from a create schema statement.

Action: Preceed the schema authorization identifier with the AUTHORIZATION keyword.

ORA-02421: missing or invalid schema authorization identifier

Cause: the schema name is missing or is incorrect in an authorization clause of a create schema statement.

Action: If the name is present, it must be the same as the current schema.

ORA-02422: missing or invalid schema element

Cause: A statement other than a create table, create view, or grant privilege appears in a create schema statement.

Action: Self-evident.

ORA-02423: schema name does not match schema authorization identifier

Cause: a table definition with a schema name prepended to the table name does not match the schema name provided in the authorization clause of a create schema statement.

Action: make sure the schema names match.

ORA-02424: potential circular view references or unknown referenced tables

Cause: the create schema statement contains views that depend on other views in the containing create schema statement or they contain references to unknown tables.

Action: create the dependent views in a separate create schema statement and make sure all referenced tables are either defined in the create schema statement or exist outside the statement.

ORA-02425: create table failed

Cause: a create table statement failed in the create schema statement.

Action: the cause for failure will be presented below this error message. Follow appropriate action(s) as suggested by the subsequent error message.

ORA-02426: privilege grant failed

Cause: a grant privilege statement failed inthe create schema statement.

Action: the cause for failure will be presented below this error message. Follow appropriate action(s) as suggested by the subsequent error message.

ORA-02427: create view failed

Cause: a create view statement failed in the create schema statement.

Action: the cause for failure will be presented below this error message. Follow appropriate action(s) as suggested by the subsequent error message.

ORA-02428: could not add foreign key reference

Cause: could not add a foreign key reference because of error in declaration. Either referenced table does not exist or table does not have an unique key.

Action: make sure referenced table exists and/or has unique key

ORA-02429: cannot drop index used for enforcement of unique/primary key

Cause: user attempted to drop an index that is being used as the enforcement mechanism for unique or primary key.

Action: drop the constraint instead of the index.

ORA-02430: cannot enable constraint (string) - no such constraint

Cause: the named constraint does not exist for this table.

Action: Obvious

ORA-02431: cannot disable constraint (string) - no such constraint

Cause: the named constraint does not exist for this table.

Action: Obvious

ORA-02432: cannot enable primary key - primary key not defined for table

Cause: Attempted to enable a primary key that is not defined for the table.

Action: Need to add a primary key definition for the table.

ORA-02433: cannot disable primary key - primary key not defined for table

Cause: Attempted to disable a primary key tht is not defined for the table.

Action: None

ORA-02434: cannot enable unique(string) - unique key not defined for table

Cause: attempted to enable a unique key that is not defined for the table.

Action: None

ORA-02435: cannot disable unique(string) - unique key not defined for table

Cause: attempted to disable a unique key that is not deined for the table.

Action: None

ORA-02436: date or system variable wrongly specified in CHECK constraint

Cause: An attempt was made to use a date constant or system variable, such as USER, in a check constraint that was not completely specified in a CREATE TABLE or ALTER TABLE statement. For example, a date was specified without the century.

Action: Completely specify the date constant or system variable. Setting the event 10149 allows constraints like "a1 > '10-MAY-96'", which a bug permitted to be created before version 8.

ORA-02437: cannot validate (string.string) - primary key violated

Cause: attempted to validate a primary key with duplicate values or null values.

Action: remove the duplicates and null values before enabling a primary key.

ORA-02438: Column check constraint cannot reference other columns

Cause: attempted to define a column check constraint that references another column.

Action: define it as a table check constriant.

ORA-02439: Unique index on a deferrable constraint is not allowed

Cause: attempted to enable a deferrable primary key/unique constraint that has an existing unique index on the constraint columns.

Action: Drop the index on the constraint columns or make the constraint not deferrable.

ORA-02440: Create as select with referential constraints not allowed

Cause: create table foo (... ref. con. ...) as select ...;

Action: Create the table as select, then alter the table to add the constraints afterwards.

ORA-02441: Cannot drop nonexistent primary key

Cause: alter table drop primary key - primary key does not exist.

Action: None

ORA-02442: Cannot drop nonexistent unique key

Cause: alter table drop unique (col list) - unique specification does not exist.

Action: make sure column list for unique constraint is correct.

ORA-02443: Cannot drop constraint - nonexistent constraint

Cause: alter table drop constraint <constraint_name>

Action: make sure you supply correct constraint name.

ORA-02444: Cannot resolve referenced object in referential constraints

Cause: attempted to define foreign key referencing an object which cannot be resolved to a base table reference

Action: referential constraints can only be defined on objects which can be resolve to base table reference

ORA-02445: Exceptions table not found

Cause: the explicity or implicity declared exceptions table does not exist.

Action: Create the table then issue the enable command again.

ORA-02446: CREATE TABLE ... AS SELECT failed - check constraint violated

Cause: An attempt was made to use a CREATE TABLE ... AS SELECT statement when some rows violated one or more CHECK constraints.

Action: Do not select rows that violate constraints.

ORA-02447: cannot defer a constraint that is not deferrable

Cause: An attempt was made to defer a nondeferrable constraint

Action: Drop the constraint and create a new one that is deferrable

ORA-02448: constraint does not exist

Cause: The named constraint does not exist

Action: Stop trying to do something with a nonexistant constraint

ORA-02449: unique/primary keys in table referenced by foreign keys

Cause: An attempt was made to drop a table with unique or primary keys referenced by foreign keys in another table.

Action: Before performing the above operations the table, drop the foreign key constraints in other tables. You can see what constraints are referencing a table by issuing the following command: SELECT * FROM USER_CONSTRAINTS WHERE TABLE_NAME = "tabnam";

ORA-02450: Invalid hash option - missing keyword IS

Cause: Missing IS keyword.

Action: Specify HASH IS option.

ORA-02451: duplicate HASHKEYS specification

Cause: The HASHKEYS option is specified more than once.

Action: Only specify the HASHKEYS option once.

ORA-02452: invalid HASHKEYS option value

Cause: The specified HASHKEYS option must be an integer value.

Action: Specify an appropriate value.

ORA-02453: duplicate HASH IS specification

Cause: The HASH IS option is specified more than once.

Action: only specify the HASH IS option once.

ORA-02454: Number of hash keys per block (string) exceeds maximum of string

Cause: The SIZE argument is too small.

Action: Increase the SIZE argument.

ORA-02455: The number of cluster key column must be 1

Cause: When specifing the HASH IS option, the number of key columns must be 1.

Action: Either do not specify the HASH IS option or reduce the number of key columns.

ORA-02456: The HASH IS column specification must be NUMBER(*,0)

Cause: The column specification must specify an integer.

Action: Specify the column definition as type NUMBER(precision, 0).

ORA-02457: The HASH IS option must specify a valid column

Cause: The HASH IS column name is not specified in the cluster definition.

Action: Specify a valid column name.

ORA-02458: HASHKEYS must be specified for a HASH CLUSTER

Cause: The HASHKEYS option must be specified when creating a HASH CLUSTER.

Action: Specify the HASHKEYS option.

ORA-02459: Hashkey value must be a positive integer

Cause: The value of the hash key was not a positive number.

Action: Specify a positive integer.

ORA-02460: Inappropriate index operation on a hash cluster

Cause: An attempt to create a cluster index was issued on a hash cluster.

Action: Do not attempt to create such an index.

ORA-02461: Inappropriate use of the INDEX option

Cause: This option is only valid for non hash clusters.

Action: Do not specify this option.

ORA-02462: Duplicate INDEX option specified

Cause: The INDEX option is specified more than once.

Action: Only specify the INDEX option once.

ORA-02463: Duplicate HASH IS option specified

Cause: The HASH IS option is specified more than once.

Action: Only specify the HASH IS option once.

ORA-02464: Cluster definition can not be both HASH and INDEX

Cause: The cluster can either be a hash or indexed cluster - not both.

Action: Remove either the HASH IS or INDEX options.

ORA-02465: Inappropriate use of the HASH IS option

Cause: This option is only valid for clusters

Action: Do not specify this option

ORA-02466: The SIZE and INITRANS options cannot be altered for HASH CLUSTERS.

Cause: An attempt was made to change the SIZE and INITRANS options after the hash cluster was created.

Action: Do not specify this option.

ORA-02467: Column referenced in expression not found in cluster definition

Cause: A column in the hash is expression was not present in cluster definition.

Action: Recreate the cluster and correct the error in hash expression.

ORA-02468: Constant or system variable wrongly specified in expression

Cause: A constant or system variable was specified in the hash expression.

Action: Recreate the cluster and correct the error in hash expression.

ORA-02469: Hash expression does not return an Oracle Number.

Cause: Result of evaluating hash expression is not an Oracle Number.

Action: Recreate the cluster and correct the error in hash expression.

ORA-02470: TO_DATE, USERENV, or SYSDATE incorrectly used in hash expression.

Cause: An attempt was made to specify SYSDATE, UID, USER, ROWNUM, or LEVEL in hash expression.

Action: Re-create the cluster and correct the error in hash expression.

ORA-02471: SYSDATE, UID, USER, ROWNUM, or LEVEL incorrectly used in hash expression.

Cause: SYSDATE, UID, USER, ROWNUM, or LEVEL are not allowed in hash expressions.

Action: Recreate the cluster and remove the offending keywords.

ORA-02472: PL/SQL functions not allowed in hash expressions

Cause: A PL/SQL function was used in the hash expression.

Action: Recreate the cluster and remove the PL/SQL function.

ORA-02473: Error while evaluating the cluster's hash expression.

Cause: An error occurred while evaluating the clusters hash expression.

Action: Correct the query and retry.

ORA-02474: Fixed hash area extents used (string) exceeds maximum allowed (string)

Cause: The number of extents required for creating the fixed hash area exceeds the maximum number allowed.

Action: Reduce the number of extents required by increasing the extent allocation sizes within the STORAGE clause.

ORA-02475: maximum cluster chain block count of string has been exceeded

Cause: The number of blocks in a cluster chain exceeds the maximum number allowed.

Action: Increase SIZE parameter in CREATE CLUSTER statement or reconsider suitability of cluster key.

ORA-02476: can not create index due to parallel direct load on table

Cause: A parallel direct load is occurring to the specified table.

Action: Retry statement after load is complete.

ORA-02477: can not perform parallel direct load on object string

Cause: A parallel direct load is not possible because an index is is being created on the table.

Action: Retry load after index creation is complete.

ORA-02478: merge into base segment would overflow MAXEXTENTS limit

Cause: Merge of temporary segment into base segment failed because MAXEXTENTS was larger than the total in the temp and base segments

Action: Use a larger value for MAXEXTENTS on the base segment or make the extents in the temporary segments larger

ORA-02479: error while translating file name for parallel load

Cause: An invalid file name was specified to load data into.

Action: Specify a valid database file.

ORA-02481: Too many processes specified for events (max string)

Cause: Too many processes specified than allowed per event.

Action: Enter fewer processes by using ranges or wildcards if possible.

ORA-02482: Syntax error in event specification (string)

Cause: Illegal event string

Action: Enter a legal event string

ORA-02483: Syntax error in process specification (string)

Cause: Illegal process string

Action: Enter a legal process string

ORA-02484: Invalid _trace_buffers parameter specification (string)

Cause: Bad process or size in _trace_buffers INIT.ORA parameter.

Action: n/a

ORA-02485: Invalid _trace_options parameter specification (string)

Cause: Bad syntax for _trace_options INIT.ORA parameter.

Action: n/a

ORA-02486: Error in writing trace file string

Cause: Error occurred in creating/writing the file.

Action: Check file name and make sure it is constructed properly. Also, check permissions for directories.

ORA-02487: Error in converting trace data

Cause: Incompatible binary trace data was specified.

Action: Check the format of the input data.

ORA-02488: Error encountered when accessing file [string] for trace conversion

Cause: An attempt was made to open or access the trace file during a trace conversion.

Action: Check the permissions for both input and output files. Also, check the file compatibility for the trace conversion.

ORA-02490: missing required file size in RESIZE clause

Cause: No value was specified for the RESIZE clause.

Action: Use correct syntax.

ORA-02491: missing required keyword ON or OFF in AUTOEXTEND clause

Cause: The keyword ON or OFF was not specified for the AUTOEXTEND clause.

Action: Use correct syntax.

ORA-02492: missing required file block increment size in NEXT clause

Cause: No value was specified for the NEXT clause.

Action: Use correct syntax.

ORA-02493: invalid file increment size in NEXT clause

Cause: A non-integer value was used for the NEXT clause of the DATAFILE list.

Action: Use correct syntax.

ORA-02494: invalid or missing maximum file size in MAXSIZE clause

Cause: UNLIMITED was not specified, or an invalid integer value was specified, for the MAXSIZE clause in the DATAFILE file list. The MAXSIZE value cannot be smaller than the SIZE value.

Action: Use correct syntax.

ORA-02495: cannot resize file string, tablespace string is read only

Cause: An attempt was made to resize a data file in a tablespace that is read only.

Action: Change the tablespace to read/write and retry the resize operation.

ORA-02700: osnoraenv: error translating ORACLE_SID

Cause: Two-task driver could not find the value of ORACLE_SID in the environment.

Action: Make sure that the ORACLE_SID environment variable has been properly set and exported.

ORA-02701: osnoraenv: error translating oracle image name

Cause: ORACLE_HOME environment variable not set.

Action: Make sure that the ORACLE_HOME environment variable has been properly set and exported.

ORA-02702: osnoraenv: error translating orapop image name

Cause: ORACLE_HOME environment variable not set.

Action: Make sure that the ORACLE_HOME environment variable has been properly set and exported.

ORA-02703: osnpopipe: pipe creation failed

Cause: The pipe driver failed to create pipes for communications with the orapop process.

Action: You have probably exceeded the maximum number of open file descriptors per user or the system file table is full. Note the operating system error code and contact your system administrator.

ORA-02704: osndopop: fork failed

Cause: The two-task driver could not fork orapop.

Action: Verify that there are enough system resources to support another process. The user or system process limit may have been exceeded, or the amount of free memory or swap space may be temporarily insufficient.

ORA-02705: osnpol: polling of communication channel failed

Cause: The pipe driver failed while polling the communications channel.

Action: Contact your customer support representative.

ORA-02706: osnshs: host name too long

Cause: The length of your host-string specified by the TWO_TASK environment variable exceeds the ORACLE system-imposed limit.

Action: Contact your customer support representative.

ORA-02707: osnacx: cannot allocate context area

Cause: The invoked Unix two-task driver could not allocate heap space for the context area.

Action: Contact your customer support representative.

ORA-02708: osnrntab: connect to host failed, unknown ORACLE_SID

Cause: The invoked Unix two-task driver failed to find an entry in oratab for the sid you supplied.

Action: First, check whether you have read access to oratab, and see if the desired sid is there. Add an entry to oratab for the desired sid, if necessary.

ORA-02709: osnpop: pipe creation failed

Cause: The pipe driver failed to create pipes for two-task communications with the oracle shadow process.

Action: You have probably exceeded the maximum number of open file descriptors per user or the system file table is full. Note the operating system error code and contact your system administrator.

ORA-02710: osnpop: fork failed

Cause: The pipe driver could not fork the oracle shadow process.

Action: Verify that there are enough system resources to support another process. The user or system process limit may have been exceeded, or the amount of free memory or swap space may be temporarily insufficient.

ORA-02711: osnpvalid: write to validation channel failed

Cause: The pipe driver failed to write to the orapop process.

Action: Contact your customer support representative.

ORA-02712: osnpop: malloc failed

Cause: The pipe driver failed to allocate enough heap space for its context area buffers.

Action: Contact your customer support representative.

ORA-02713: osnprd: message receive failure

Cause: The pipe driver failed to read a message from the communications channel.

Action: Contact your customer support representative.

ORA-02714: osnpwr: message send failure

Cause: The pipe driver failed to write a message to the communications channel.

Action: Contact your customer support representative.

ORA-02715: osnpgetbrkmsg: message from host had incorrect message type

Cause: The pipe driver received a message having an unrecognizable message type.

Action: Contact your customer support representative.

ORA-02716: osnpgetdatmsg: message from host had incorrect message type

Cause: The Pipe driver received a message having an unrecognizable message type.

Action: Contact your customer support representative.

ORA-02717: osnpfs: incorrect number of bytes written

Cause: The Pipe driver sent a message that was apparently successful, but the number of bytes transmitted did not match the number of bytes furnished to the driver.

Action: Contact your customer support representative.

ORA-02718: osnprs: reset protocol error

Cause: The two-task driver could not reset the connection.

Action: Contact your customer support representative.

ORA-02719: osnfop: fork failed

Cause: The fast driver could not fork the oracle shadow process.

Action: Verify that there are enough system resources to support another process. The user or system process limit may have been exceeded, or the amount of free memory or swap space may be temporarily insufficient.

ORA-02720: osnfop: shmat failed

Cause: When the fast driver was invoked, processes failed to attach to the shared memory buffer. You probably supplied an illegal shared memory attach address, or the system ran out of data space to accomodate the buffer.

Action: Try invoking the Fast driver later, or use the default attach address.

ORA-02721: osnseminit: cannot create semaphore set

Cause: The Fast driver failed to get a semaphore set.

Action: The system-imposed limit on semaphores or semaphore identifiers may have been exceeded. Read the returned operating system error code and check with your system administrator.

ORA-02722: osnpui: cannot send break message to orapop

Cause: The Pipe driver could not send a break message to orapop.

Action: Contact your customer support representative.

ORA-02723: osnpui: cannot send break signal

Cause: The Pipe driver could not send a break message to the ORACLE shadow process.

Action: Contact your customer support representative.

ORA-02724: osnpbr: cannot send break message to orapop

Cause: The Pipe driver could not send a break message to orapop.

Action: Contact your customer support representative.

ORA-02725: osnpbr: cannot send break signal

Cause: The Pipe driver could not send a break message to the ORACLE shadow process.

Action: Kill system call failed. Check errno and contact customer support.

ORA-02726: osnpop: access error on oracle executable

Cause: The Pipe driver could not access the oracle executable.

Action: Check the permissions on the ORACLE executable and each component of the ORACLE_HOME/bin path.

ORA-02727: osnpop: access error on orapop executable

Cause: The Pipe driver could not access the orapop executable.

Action: Check the permissions on the orapop executable and each component of the ORACLE_HOME/bin path.

ORA-02728: osnfop: access error on oracle executable

Cause: The Fast driver could not access the oracle executable.

Action: Check the permissions on the ORACLE executable and each component of the ORACLE_HOME/bin path.

ORA-02729: osncon: driver not in osntab

Cause: The driver you have specified is not supported.

Action: Check with your database administrator which drivers are supported.

ORA-02730: osnrnf: cannot find user logon directory

Cause: The driver you have specified could not find your logon directory while searching for your local .sqlnet file.

Action: Set and export the HOME environment variable to identify your home directory. Check with your system administrator to make sure that your uid and home directory are correct in the /etc/passwd file.

ORA-02731: osnrnf: malloc of buffer failed

Cause: The specified driver could not find enough heap space to malloc a buffer.

Action: Contact your customer support representative.

ORA-02732: osnrnf: cannot find a matching database alias

Cause: Database alias specified was not identified in either $HOME/.sqlnet or /etc/sqlnet.

Action: Create the alias in a file called .sqlnet in your home directory for personal use or ask your system administrator to create the alias in /etc/sqlnet for system-wide use.

ORA-02733: osnsnf: database string too long

Cause: While converting a database alias to a database ID, the resulting database ID string exceeded the ORACLE system-imposed limit.

Action: Contact your customer support representative.

ORA-02734: osnftt: cannot reset shared memory permission

Cause: The Fast driver was unable to reset shared memory permissions.

Action: Contact your customer support representative.

ORA-02735: osnfpm: cannot create shared memory segment

Cause: The Fast driver failed to create a shared memory segment for two-task communication.

Action: Check whether the system-imposed limit on shared memory identifiers has already been reached for your system.

ORA-02736: osnfpm: illegal default shared memory address

Cause: The Fast driver failed to establish a default shared memory address.

Action: Contact your customer support representative.

ORA-02737: osnpcl: cannot tell orapop to exit

Cause: The Pipe driver failed to send orapop the command to exit.

Action: Contact your customer support representative.

ORA-02738: osnpwrtbrkmsg: incorrect number of bytes written

Cause: The pipe driver apparently sent an imcomplete break message.

Action: Contact your customer support representative.

ORA-02739: osncon: host alias is too long

Cause: The alias used for a sqlnet host is longer than 161 characters.

Action: Use a shorter alias.

ORA-02750: osnfsmmap: cannot open shared memory file ?/dbs/ftt_pid.dbf

Cause: The Fast driver failed to create a shared memory file for two-task communication.

Action: Check the permissions on the directory ?/dbs

ORA-02751: osnfsmmap: cannot map shared memory file

Cause: The Fast driver failed to map a shared memory file for two-task communication.

Action: Contact your customer support representative.

ORA-02752: osnfsmmap: illegal shared memory address

Cause: The Fast driver failed to attach shared memory at the expected location.

Action: Contact your customer support representative.

ORA-02753: osnfsmmap: cannot close shared memory file

Cause: The Fast driver cannot close the shared memory file.

Action: Contact your customer support representative.

ORA-02754: osnfsmmap: cannot change shared memory inheritence

Cause: The Fast driver could not alter the inheritence attributes of the shared memory.

Action: Contact your customer support representative.

ORA-02755: osnfsmcre: cannot create chared memory file ?/dbs/ftt_pid.dbf

Cause: The Fast driver failed to create a file for shared memory.

Action: Check the permissions on the directory ?/dbs

ORA-02756: osnfsmnam: name translation failure

Cause: The Fast driver encountered an error translating the shared memory filename ?/dbs/ftt_pid.dbf.

Action: Contact your customer support representative.

ORA-02757: osnfop: fork_and_bind failed

Cause: The Fast driver failed to fork a process onto the desired cluster and node number.

Action: Check the desired node number in sercose[0] and cluster ID in sercose[1]. If these seem valid, contact customer support.

ORA-02758: Allocation of internal array failed

Cause: The package was unable to allocate memory for an array because the system ran out of memory.

Action: Either reclaim memory by killing other processes or reboot the machine with more memory.

ORA-02759: Not enough request descriptors available

Cause: All of the package's request descriptors are in use performing other requests.

Action: Either wait until enough requests are done, or shut the package down and re-initialize it with more request descriptors.

ORA-02760: Client close of file failed.

Cause: The client was unable to close a file after forking the servers.

Action: This is a system problem - contact your System Administrator.

ORA-02761: File number to be canceled is negative.

Cause: The file number contained with the sfiov structure is less than zero.

Action: This may be a programming error. If it is not, contact ORACLE support.

ORA-02762: file number to be cancelled is greater than the maximum.

Cause: The file number contained with the sfiov structure is greater than the maximum.

Action: This may be a programming error. If it is not, contact ORACLE support.

ORA-02763: Unable to cancel at least one request

Cause: No requests were found that could be cancelled.

Action: This error can occur if all the requests dealing with that file number have already been filled.

ORA-02764: Invalid package mode

Cause: The mode of the package can only be parallel or duplex.

Action: See sfa.h for the correct values.

ORA-02765: Invalid maximum number of servers

Cause: The number of servers given was less than or equal to zero.

Action: Use a number greater than zero.

ORA-02766: Invalid maximum of request descriptors

Cause: The number of request descriptors was less than or equal to zero.

Action: Use a number greater than zero.

ORA-02767: Less than one request descriptor was allocated per server

Cause: The package requires that the number of request descriptors be greater than or equal to the number of servers used.

Action: Use a higher number

ORA-02768: Maximum number of files is invalid

Cause: The maximum number of files to be used by the package was less than or equal to zero.

Action: Use a positive number.

ORA-02769: Setting of handler for SIGTERM failed

Cause: The package was unable to set up handling by the server for the termination signal. This is an internal error.

Action: Contact ORACLE support.

ORA-02770: Total number of blocks is invalid

Cause: The total number of blocks to be allocated for use by the package was not greater than zero.

Action: Use a positive number.

ORA-02771: Illegal request time out value

Cause: The number was not a positive number.

Action: Use a positive number.

ORA-02772: Invalid maximum server idle time

Cause: The time given was not a positive number.

Action: Use a positive number.

ORA-02773: Invalid maximum client wait time

Cause: The time given was not a positive number.

Action: Use a positive number.

ORA-02774: Invalid request list latch time out value

Cause: The time given was not a positive number.

Action: Use a positive number.

ORA-02775: Invalid request done signal

Cause: The signal number was not a positive number.

Action: Use a positive number.

ORA-02776: Value for request done signal exceeds maximum

Cause: The value sent to the package for use as the "request done" signal exceeds the maximum allowed by the operating system.

Action: n/a

ORA-02777: Stat failed on log directory

Cause: The package was unable to get information about the directory in which the log files are to reside.

Action: Check the permissions on the directory or use a different directory name.

ORA-02778: Name given for the log directory is invalid

Cause: The name given for the directory in which the logs are to be kept does not correspond to a directory.

Action: Use a different name.

ORA-02779: Stat failed on core dump directory

Cause: The package was unable to get information about the directory into which the servers are to dump core in the event of an exception.

Action: Check the permissions on the directory or use a different directory name.

ORA-02780: Name given for the core dump directory is invalid

Cause: The name given for the directory in which the server processes are to dump core in the event of an exception does not correspond to a directory.

Action: Use a different name.

ORA-02781: Invalid value given for the timing wanted flag

Cause: The value given was not TRUE or FALSE.

Action: n/a

ORA-02782: Both read and write functions were not specified

Cause: To ensure that the functions act symmetrically, pointers to both the read and write functions must be given.

Action: Either specify both functions or specify neither. The package will supply its own functions.

ORA-02783: Both post and wait functions were not specified

Cause: To ensure that the functions act symmetrically, pointers to both the posting and waiting functions must be given.

Action: Either specify both functions or specify neither. The package will supply its own functions.

ORA-02784: Invalid shared memory ID specified

Cause: The ID of the segment specified for use as the shared buffer region was invalid.

Action: Use a different ID, or let the package specify its own.

ORA-02785: Invalid shared memory buffer size

Cause: The size given for the shared memory segment to be used as the shared buffer region was less than or equal to zero.

Action: Use a positive number.

ORA-02786: Size needed for shared region is greater than segment size

Cause: The size of the shared segment that was specified for the shared buffer region is less than the number of bytes required. The first field of the "additional information" field is the size needed. The second is the size of the segment.

Action: Use a larger size segment or let the package allocate its own.

ORA-02787: Unable to allocate memory for segment list

Cause: The package cannot allocate memory for an internal segment list because the system has run out of memory. The "additional information" field is the amount of memory that the package attempted to allocate.

Action: n/a

ORA-02788: Unable to find kernel process pointer in async process array

Cause: Internal error - Contact ORACLE support.

Action: n/a

ORA-02789: Maximum number of files reached

Cause: The maximum number of files that can be used for asynchronous I/O has been reached.

Action: Shut down the servers and re-initialize the package with a higher number.

ORA-02790: File name is too long

Cause: The length of the name of a file that is being opened for asynchronous I/O is longer than the maximum. The "additional information" field is the maximum length.

Action: Use a shorter name.

ORA-02791: Unable to open file for use with asynchronous I/O

Cause: The package could not open file for some reason.

Action: Check the file name.

ORA-02792: Unable to fstat() a file being used for asynchronous I/O.

Cause: The fstat(2) call on a file being used for asynchronous I/O failed.

Action: Check the file name.

ORA-02793: Close of asynchronous I/O failed.

Cause: The client was unable to close a file being used for asynchronous I/O.

Action: Contact ORACLE support - this should not happen.

ORA-02794: Client unable to get key for shared memory

Cause: The client was unable to get a key so that it obtain shared memory for use with shared memory.

Action: Contact ORACLE support - this is an internal error.

ORA-02795: Request list is empty

Cause: The client was signalled by a server that it was done with a request but the "done" list was empty.

Action: Internal error - contact ORACLE support.

ORA-02796: Done request is not in correct state

Cause: A request is not in the right state.

Action: Internal error - contact ORACLE support.

ORA-02797: No requests available

Cause: No free request descriptors are available.

Action: Wait until some requests are filled and then retry the request, or shutdown the servers and initialize the package with a higher number of requests.

ORA-02798: Invalid number of requests

Cause: The number of operations sent to either sfard() or sfawrite() is less than zero.

Action: This is a user programming error.

ORA-02799: Unable to arm signal handler

Cause: The arming of a signal handler for the "done" signal failed.

Action: Internal error - contact ORACLE support.

ORA-02800: Requests timed out

Cause: Some of the requests for asynchronous input or output were not serviced in the required amount of time.

Action: If the load on the system is high, it is possible that the timeout limit is too low. Reset it with sfainit(). If the server processes are dying due to unexpected signals, this is an internal error, and ORACLE support should be contacted.

ORA-02801: Operations timed out

Cause: Some asynchronous operations timed out in kernel mode.

Action: Internal error - contact ORACLE support.

ORA-02802: No idle servers available in parallel mode

Cause: Internal error.

Action: Contact ORACLE support.

ORA-02803: Retrieval of current time failed

Cause: Internal error.

Action: Contact ORACLE support.

ORA-02804: Allocation of memory failed for log file name

Cause: The client was unable to allocated a buffer for the name of the log file.

Action: Contact your System Administrator.

ORA-02805: Unable to set handler for SIGTPA

Cause: Internal error.

Action: Contact ORACLE support.

ORA-02806: Unable to set handler for SIGALRM

Cause: Internal error.

Action: Contact ORACLE support.

ORA-02807: Allocation of memory for I/O vectors failed.

Cause: The client was unable to allocate memory for the array of I/O vectors that the servers are to use.

Action: Contact your System Administrator.

ORA-02808: Allocation of memory of open files array failed.

Cause: The client was unable to allocate memory for an array of flags that the servers are to use.

Action: Contact your System Administrator.

ORA-02809: Jump buffer not valid

Cause: Internal error.

Action: Contact ORACLE support.

ORA-02810: Unable to make temporary file name for memory mapped file
ORA-02811: Unable to attach shared memory segment
ORA-02812: Bad attach address
ORA-02813: Unable to make temporary file name in order to get key

Cause: Internal error.

Action: Contact ORACLE support.

ORA-02814: Unable to get shared memory

Cause: Shmget(2) failed.

Action: Check the UNIX number. If you are unsure about what it means, contact ORACLE customer support.

ORA-02815: Unable to attach shared memory

Cause: Shmat(2) failed.

Action: Check the UNIX number. If you are unsure about what it means, contact ORACLE customer support.

ORA-02816: Unable to kill a process

Cause: A server did not die after being sent a kill signal.

Action: The process may be a runaway - contact ORACLE customer support.

ORA-02817: Read failed

Cause: A server could not read a requested amount of data.

Action: Check the call to sfard(). An incorrect file descriptor may have been sent to sfard(). The number in the "additional information" field is the starting block number of the data segment being read in.

ORA-02818: Less than the number of blocks requested was read in

Cause: A server could not read in the request amount of data. The first number in the "additional information" field is the block number being read in. The second is the actual number of bytes that was read in.

Action: This is a programming error.

ORA-02819: Write failed

Cause: A server was unable to perform a write. The number in the "additional information" field is the starting block number of the data segment being written out. The first number in the "additional information" field is the block number being written out. The second is the actual number of bytes that was written out. The disk may have filled up.

Action: Check the UNIX error number.

ORA-02820: Unable to write the requested number of blocks

Cause: A server could not write the requested amount of data out to disk. The disk may have run out of space.

Action: Check the UNIX error number.

ORA-02821: Unable to read the requested number of blocks.

Cause: A server could not read the number of blocks that was requested. The end of the file may have been read.

Action: Check the file on disk.

ORA-02822: Invalid block offset

Cause: A server was unable to seek to the designated block.

Action: Check the UNIX error number.

ORA-02823: Buffer is not aligned.

Cause: The buffer on which an I/O is being done is not on the correct boundary.

Action: Check the calling program.

ORA-02824: Request free list is empty

Cause: The list from which the package allocates request descriptors is empty because all of the descriptors is in use.

Action: Wait until some become free, or initialize the package with a higher number of request descriptors.

ORA-02825: Request on free list was not free

Cause: Internal error.

Action: Contact ORACLE support.

ORA-02826: Illegal block size

Cause: A negative number was given for the I/O block size to be used by the asynchronous I/O package.

Action: This is a programming error - use either a positive number or zero to get the default value.

ORA-02827: Invalid file number

Cause: The file number upon which an operation is to done is either less than zero or greater than the maximum number of files than can be open.

Action: This is a programming error. Since the calling program should not touch this number, this is a programming error.

ORA-02828: Segment free list is empty

Cause: No segments are available to allocated.

Action: Free some segments or shut down the package and re-initialize it with a higher number of segments.

ORA-02829: No segment of the proper size is available

Cause: No segment of the proper size is ready for use by the caller.

Action: Free some segments and try again.

ORA-02830: Segment could not be split - no free segments available

Cause: A segment that is larger than that desired could not be split because no free segment was available.

Action: Free some segments and try again.

ORA-02831: Segment deallocation failed - empty segment list

Cause: The caller attempted to deallocate a segment but the "in use" list was empty. This is a programming error.

Action: Check the calling program.

ORA-02832: Segment deallocation failed - segment not on list

Cause: The caller attempted to deallocate a segment that was not on the "in use" list. This is a programming error.

Action: Check the calling program.

ORA-02833: Server was unable to close file

Cause: A server was unable to close a file being used for asynchronous I/O.

Action: See the UNIX error number for more information.

ORA-02834: Server unable to open file

Cause: The server was unable to open a file for use with asynchronous I/O.

Action: Check the UNIX error number for more information.

ORA-02835: Server unable to send signal to client

Cause: Internal error.

Action: Contact ORACLE support.

ORA-02836: Unable to create temporary key file

Cause: Internal error.

Action: Contact ORACLE support.

ORA-02837: Unable to unlink temporary file

Cause: Internal error.

Action: Contact ORACLE support.

ORA-02838: Unable to arm signal handler for the alarm signal

Cause: The arming of a signal handler for the alarmsignal failed.

Action: Internal error - contact ORACLE support.

ORA-02839: Sync of blocks to disk failed.

Cause: The server was unable to flush its writes out to disk.

Action: Check the UNIX error number.

ORA-02840: Open of log file by client failed

Cause: The client process was unable to open its log file.

Action: Check the UNIX error number for more information.

ORA-02841: Server died on start up

Cause: A server exited during its initialization process.

Action: Check the servers' logs for more information.

ORA-02842: Client unable to fork a server

Cause: The client could not spawn a server. A possible reason is that the operating system has reached its limit on the number of processes that it can spawn.

Action: Either reduce the number of servers that are to be used, or reconfigure the operating system so that it can handle more processes.

ORA-02843: Invalid value for kernel flag

Cause: An illegal value was given for the kernel flag in the information structure. Only TRUE and FALSE are permitted.

Action: This is a programming error - check the calling routine.

ORA-02844: Invalid value for the leave open flag

Cause: A value was given for the flag that determines whether a file is to be left open after the client checks it to see if the servers can use it. Only TRUE and FALSE are supported.

Action: This is a programming error - check the calling routine.

ORA-02845: Invalid value for the timing wanted flag

Cause: A value was given for the flag that indicates that operations are to be timed out. Only TRUE and FALSE are supported.

Action: This is a programming error - check the calling routine.

ORA-02846: Unkillable server

Cause: A server would not respond to the termination signal. The first number is the number of the server. The second is its UNIX process number. This is an internal problem.

Action: This is an operating system problem.

ORA-02847: Server did not terminate when posted

Cause: A server did not respond to a posted request to shutdown. The first number is the number of the server. The second is its UNIX process number. This is an internal problem.

Action: Contact ORACLE support.

ORA-02848: Asynchronous I/O package is not running

Cause: An operation using the asynchronous I/O package was attempted without first initializing the package using sfainit().

Action: Call sfainit() before using the package.

ORA-02849: Read failed because of an error

Cause: A server could not read the requested amount of data from disk.

Action: Check the UNIX error number.

ORA-02850: File is closed

Cause: A file upon which an asynchronous I/O operation is to be performed has already been closed by the package.

Action: This is a programming error.

ORA-02851: Request list is empty when it should not be

Cause: This is an internal problem.

Action: Contact ORACLE support.

ORA-02852: Invalid critical-section time out value

Cause: The time given was not a positive number.

Action: Use a positive number.

ORA-02853: Invalid server list latch time out value

Cause: The time given was not a positive number.

Action: Use a positive number.

ORA-02854: Invalid number of request buffers

Cause: The value given for "db_slave_buffers" in your INIT.ORA file is less than 0.

Action: Use a number that is greater than or equal to 0.

ORA-02855: Number of requests is less than the number of slaves

Cause: The value given for 'db_slave_buffers' in the initialization parameter file was less than the number specified for the number of slaves, 'db_slaves.'

Action: Specify a number that is greater than that given for 'db_slaves.' Alternatively, specify 0. The kernel will supply the appropriate number.

ORA-02875: smpini: Unable to get shared memory for PGA

Cause: Stated in errno.

Action: Resolve the problem.

ORA-02876: smpini: Unable to attach to shared memory for PGA

Cause: Stated in errno.

Action: Resolve the problem.

ORA-02877: smpini: Unable to initialize memory protection

Cause: The adspcinit program has not been executed.

Action: Execute the adscpinit program as shown in your Installation and Users' Guide. If the problem persists, try rebooting your computer.

ORA-02878: sou2o: Variable smpdidini overwritten

Cause: The variable smpdidini was overwritten, probably by client code.

Action: Verify client code, e.g. Pro*C, for illegal memory access. If the problem occurs outside Single Task operation, contact your customer support representative.

ORA-02879: sou2o: Could not gain access to protected memory

Cause: This is an internal error, note error code in errno.

Action: Report to your customer support representative. Restarting your application or your computer may cure the problem.

ORA-02880: smpini: Could not register PGA for protection

Cause: This is an internal error, note error code in errno.

Action: Report to your customer support representative. Restarting your application or your computer may cure the problem.

ORA-02881: sou2o: Could not revoke access to protected memory

Cause: This is an internal error, note error code in errno.

Action: Report to your customer support representative. Restarting your application or your computer may cure the problem.

ORA-02882: sou2o: Could not register SGA for protection

Cause: This is an internal error, note error code in errno.

Action: Report to your customer support representative. Restarting your application or your computer may cure the problem.

ORA-02899: smscre: Cannot create SGA with Extended Shared Memory feature

Cause: The environment variable EXTSHM was set before starting oracle.

Action: Unset the environment variable EXTSHM and startup oracle.

ORA-03001: unimplemented feature

Cause: This feature is not implemented.

Action: None

ORA-03002: operator not implemented

Cause: This is an internal error.

Action: Contact your customer support representative.

ORA-03007: obsolete feature

Cause: User attempted to use a feature which is no longer supported.

Action: None

ORA-03009: Incompatible OCI function call

Cause: An incompatible OCI function call was issued for new functionality.

Action: Do not use V7 OCI calls for this functionality.

ORA-03100: communication area cannot be allocated; insufficient memory
ORA-03105: internal protocol error
ORA-03106: fatal two-task communication protocol error
ORA-03107: oranet buffer underflow
ORA-03108: oranet: ORACLE does not support this interface version
ORA-03109: oranet buffer overflow
ORA-03110: oranet: ORACLE does not support this SQL version
ORA-03111: break received on communication channel
ORA-03112: a server linked as single-task cannot use SQL*Net

Cause: A statement containing a SQL*Net connect string was issued to the single-task server. For example, a database link was used in a SQL statement.

Action: Do not use SQL*Net connect strings in a single-task environment.

ORA-03113: end-of-file on communication channel

Cause: The connection between Client and Server process was broken.

Action: There was a communication error that requires further investigation. First, check for network problems and review the SQL*Net setup. Also, look in the alert.log file for any errors. Finally, test to see whether the server process is dead and whether a trace file was generated at failure time.

ORA-03114: not connected to ORACLE
ORA-03115: unsupported network datatype or representation
ORA-03116: invalid buffer length passed to a conversion routine
ORA-03117: two-task save area overflow
ORA-03118: two-task coroutine has invalid state
ORA-03119: two-task detected inconsistent datatype specification

Cause: There was both a datatype, and an anonymous datatype declaration found.

Action: Correct the specification.

ORA-03120: two-task conversion routine: integer overflow
ORA-03121: no interface driver connected - function not performed
ORA-03122: attempt to close ORACLE-side window on user side

Cause: This is an internal error.

Action: Contact your customer support representative.

ORA-03123: operation would block

Cause: This is a status code that indicates that the operation cannot complete now.

Action: None; this is not an error. The operation should be retried again for completion.

ORA-03124: two-task internal error

Cause: Internal error.

Action: Contact your customer support representative.

ORA-03125: client-server protocol violation

Cause: The application received a bad escape sequence from the server and may indicate a problem with the client application user code.

Action: Contact your customer support representative.

ORA-03126: network driver does not support non-blocking operations

Cause: A non-blocking operation was attempted and the network driver does not support non-blocking operations.

Action: Use default blocking operations or use a driver supporting non-blocking operations.

ORA-03127: no new operations allowed until the active operation ends

Cause: An attempt was made to execute a new operation before the active non-blocking operation completed or a new operation was attempted before all the pieces of a column were inserted or fetched.

Action: Execute the new operation after the non-blocking operation completes. If piecewise binds/defines were done, execute the new operation after all the pieces have been inserted or fetched.

ORA-03128: connection is in blocking mode

Cause: The OCI test for non-blocking mode on a connection indicates that the connection is in blocking mode.

Action: If non-blocking mode is required use appropriate OCI calls to change the mode.

ORA-03129: the next piece to be inserted is required

Cause: The application performed a piecewise bind on a column.

Action: Provide the next piece of this bind variable.

ORA-03130: the buffer for the next piece to be fetched is required

Cause: The application performed a piecewise define on the column.

Action: Provide the next buffer for the next piece to be retrieved.

ORA-03131: an invalid buffer was provided for the next piece

Cause: The application either provided the length of the buffer for the next piece to be zero or provided a null pointer.

Action: Verify if the buffer pointer for the next piece is null or if the length is zero.

ORA-03132: two-task default value overflow

Cause: The default value specified for a record field was too large.

Action: Change the default value to fit the field size.

ORA-03134: Connections to this server version are no longer supported.

Cause: An attempt was made to connect to an Oracle server of older version.

Action: Please refer to documentation for more details.

ORA-03135: connection lost contact

Cause: 1) Server unexpectedly terminated or was forced to terminate. 2) Server timed out the connection.

Action: 1) Check if the server session was terminated. 2) Check if the timeout parameters are set properly in sqlnet.ora.

ORA-03136: inbound connection timed out

Cause: Inbound connection was timed out by the server because user authentication was not completed within the given time specified by SQLNET.INBOUND_CONNECT_TIMEOUT or its default value

Action: 1) Check SQL*NET and RDBMS log for trace of suspicious connections. 2) Configure SQL*NET with a proper inbound connect timeout value if necessary.

ORA-03137: TTC protocol internal error : [string] [string] [string] [string] [string] [string] [string] [string]

Cause: TTC protocol internal error.

Action: Contact Oracle Support Services.

ORA-03138: Connection terminated due to security policy violation

Cause: Connection was terminated due to a security policy violation.

Action: Contact the Database Administrator

ORA-03139: This OCI call has been disabled by the DBA

Cause: The SEC_DISABLE_OLDER_ORACLE_RPCS initialization parameter was enabled.

Action: Contact the Database Administrator

ORA-03140: I/O operation in progress

Cause: The current I/O operation was not complete. The error is typically returned from vectored and/or asynchronous I/O calls.

Action: Perform the necessary operation to complete or abort the current I/O.

ORA-03141: I/O request queue full

Cause: The I/O request queue was full and no more requests could be queued.

Action: Perform the proper operations to complete part or all of the current in-progress I/O requests.

ORA-03142: Session ID: number Serial number: number

Cause: Connection was lost for the specified session and serial number. This is either due to session being killed or network problems.

Action: Reconnect and if error persists, contact Oracle Support Services.

ORA-03143: Process ID: string Thread ID: string

Cause: Connection was lost for the specified process ID and thread ID. This is either due to session being killed or network problems.

Action: Reconnect and if error persists, contact Oracle Support Services.

ORA-03144: Process ID: string

Cause: Connection was lost for the specified process ID. This is either due to session being killed or network problems.

Action: Reconnect and if error persists, contact Oracle Support Services.

ORA-03145: I/O streaming direction error

Cause: Attempted to PUT data when GET streaming was in progress or attempted to GET data when PUT streaming was in progress.

Action: Complete current stream read or write I/O before attempting I/O in reverse direction.

ORA-03146: Invalid buffer length for TTC field

Cause: A corrupt Two-Task Common (TTC) packet was received.

Action: This is a internal protocol error. Contact Oracle Support Services.

ORA-03147: Missing mandatory TTC field

Cause: A corrupt Two-Task Common (TTC) packet was received.

Action: This is an internal protocol error. Contact Oracle Support Services.

ORA-03148: OCI_ATTR_ROW_COUNT cannot return a row count exceeding UB4MAXVAL. The actual row count is [string]

Cause: The row count was larger than UB4MAXVAL. OCI clients using OCI_ATTR_ROW_COUNT cannot see row counts larger than UB4MAXVAL.

Action: Upgrade Oracle client to version 12 client libraries or higher and use OCI_ATTR_UB8_ROW_COUNT instead.

ORA-03149: Invalid Oracle error code

Cause: An invalid Oracle error code was received by the server.

Action: This is an internal protocol error. Contact Oracle Support Services.

ORA-03150: end-of-file on communication channel for database link

Cause: The connection between the client and the remote server process was broken.

Action: Look in the alert.log file of the remote server for any errors. Also, check to see whether the remote server process is dead and whether a trace file was generated at failure time.

ORA-03160: An invalid client operation was requested by the server

Cause: You are using an Oracle client application linked with libraries with lower version than the current server version.

Action: Upgrade client libraries to be same as or higher than the server version.

ORA-03170: deadlocked on readable physical standby (undo segment string)

Cause: A new undo segment was added. A query can occasionally deadlock when issued around the time an undo segment is added and used immediately on the primary.

Action: Retry the query. Avoid creating new undo segments when using standby as a regular part of operation.

ORA-03171: Recovery was terminated during query execution

Cause: Recovery was terminated. A query can ocassionally deadlock when recovery is terminated because it needs a block with changes that are made after the point at which recovery was terminated.

Action: Retry the query. Avoid cancelling recovery on standby.

ORA-03172: STANDBY_MAX_DATA_DELAY of string seconds exceeded

Cause: Standby recovery fell behind the STANDBY_MAX_DATA_DELAY requirement.

Action: Tune recovery and retry the query later, or switch to another standby database within the data delay requirement.

ORA-03173: Standby may not be synced with primary

Cause: ALTER SESSION SYNC WITH PRIMARY did not work because either the standby was not synchronous or in a data-loss mode with regard to the primary, or the standby recovery was terminated.

Action: Make the standby synchronous and no-data-loss with regard to the primary. Make the standby recovery active.

ORA-03174: STANDBY_MAX_DATA_DELAY does not apply to SYS users

Cause: ALTER SESSION SET STANDBY_MAX_DATA_DELAY did not work for SYS users.

Action: Issue ALTER SESSION SET STANDBY_MAX_DATA_DELAY for non-SYS users.

ORA-03175: parameter string mismatch

Cause: The value of the %s parameter was not the same in all instances.

Action: Check %s in all instances.

ORA-03176: string only works on an open physical standby database

Cause: The database was not an open physical standby database.

Action: Issue the command on an open physical standby database.

ORA-03177: enable read-only violation logging
ORA-03178: duplicate SESSION or GLOBAL specifications

Cause: Duplicate SESSION or GLOBAL specifications were specified.

Action: Remove the duplicate specification.

ORA-03179: NOCACHE or ORDER sequences cannot be accessed from Active Data Guard standby

Cause: NOCACHE or ORDER sequences were not supported for Active Data Guard standby.

Action: Alter the sequence properties.

ORA-03180: Sequence values cannot be allocated for Oracle Active Data Guard standby.

Cause: Connection to the corresponding primary database failed. The primary database might be down.

Action: Try again later.

ORA-03181: Sequence object no longer exists for Oracle Active Data Guard standby.

Cause: The sequence object might have been dropped by the primary database.

Action: Check the sequence status on the primary database.

ORA-03182: The sequence object is no longer a global sequence for Oracle Active Data Guard standby database.

Cause: The sequence object might have been altered by the primary database.

Action: Check the sequence status on the primary database.

ORA-03200: the segment type specification is invalid

Cause: segment type is not TABLE, INDEX, or CLUSTER

Action: use a correct segment type

ORA-03201: the group number specification is invalid

Cause: the freelist group number was either negative or larger than the the number of freelist groups in the segment

Action: use a correct group number

ORA-03202: the scan limit specification is invalid

Cause: the scan limit did not have a positive integer value the number of freelist groups in the segment

Action: use a correct scan limit

ORA-03203: concurrent update activity makes space analysis impossible

Cause: high volume of user updates interfere with the space analysis

Action: retry the command or lock the underlying objects

ORA-03204: the segment type specification should indicate partitioning

Cause: partition name is specified for the space analysis, but the object type does not indicate parttitioning

Action: specify PARTITION in the segment type, if the object is partitioned, otherwise, omit the partition name

ORA-03205: partition name is required when partitioned type is specified

Cause: partition name is not specified for the space analysis, but the object type indicates parttitioning

Action: specify partition name, if the object is partitioned, otherwise, specify a non-partitioned type

ORA-03206: maximum file size of (string) blocks in AUTOEXTEND clause is out of range

Cause: The maximum file size for an autoextendable file has exceeded the maximum number of blocks allowed.

Action: Reduce the size and retry.

ORA-03207: subpartitioned type must be specified for composite object

Cause: partition type is specified for the space analysis, but the object type indicates composite partitioning

Action: specify subpartition name and subpartition type

ORA-03208: partitioned type must be specified for a non-composite object

Cause: subpartition type is specified for the space analysis, but the object type indicates non-composite partitioning

Action: specify partition name and partition type

ORA-03209: DBMS_ADMIN_PACKAGE invalid file/block specification

Cause: The value of file number or block number is outside of limits or inconsistent

Action: Fix the file number/block number value

ORA-03210: DBMS_ADMIN_PACKAGE invalid option specification

Cause: The value of one of the option parameters is incorrect

Action: Fix the option value

ORA-03211: The segment does not exist or is not in a valid state

Cause: The segment specified in the DBMS_SPACE_ADMIN or DBMS_SPACE operation does not exist or is not in a state appropriate for this operation

Action: Fix the segment specification, or put the segment in the appropriate state.

ORA-03212: Temporary Segment cannot be created in locally-managed tablespace

Cause: Attempt to create a temporary segment for sort/hash/lobs in in permanent tablespace of kind locally-managed

Action: Alter temporary tablespace of user to a temporary tablespace or a dictionary-managed permanent tablespace

ORA-03213: Invalid Lob Segment Name for DBMS_SPACE package

Cause: The Lob Segment specified in the DBMS_SPACE operation does not exist.

Action: Fix the Segment Specification

ORA-03214: File Size specified is smaller than minimum required

Cause: File Size specified for add/resize datafile/tempfile does not allow for the minimum required of one allocation unit.

Action: Increase the specification for file size

ORA-03215: File Size specified for resize is too small

Cause: File Size specified for resize datafile/tempfile causes bitmap control structures to overlap

Action: Increase the specification for file size

ORA-03216: Tablespace/Segment Verification cannot proceed

Cause: Corruptions detected during verification whch cannot be dealt with

Action: Do manual verification

ORA-03217: invalid option for alter of TEMPORARY TABLESPACE

Cause: invalid option for alter of temporary tablespace was specified

Action: Specify one of the valid options: ADD TEMPFILE, TEMPFILE ONLINE, TEMPFILE OFFLINE

ORA-03218: invalid option for CREATE/ALTER TABLESPACE

Cause: invalid option for create/alter tablespace of type locally-managed

Action: Specify one of the valid options.

ORA-03219: Tablespace 'string' is dictionary-managed, offline or temporary

Cause: Operation which is only applicable to permanent, online, locally-managed tablespaces is specified for a tablespace which is either dictionary-managed, offline or temporary

Action: Reissue operation for a different tablespace, mount the tablespace or do not issue it at all, since it does not apply for the given tablespace

ORA-03220: DBMS_ADMIN_PACKAGE required parameter is NULL or missing

Cause: Some of the procedures was called with missing or NULL parameters

Action: Specify the missing parameter

ORA-03221: Temporary tablespaces and temporary segments must have standard block size

Cause: An attempt was made to do one of the following : (1) create a temporary tablespace with a non-standard block size or, (2) alter an existing permanent tablespace of non-standard block size to a temporary tablespace or, (3) issue a DDL statement that would result in the creation of a temporary segment in a tablespace of non-standard block size.

Action: (1) If creating a temporary tablespace, do not specify a block size different from the standard block size. (2) If altering an existing permanent tablespace to a temporary tablespace, ensure that it is of standard block size. (3) Ensure that the user's temporary tablespace is a tablespace having the standard block size.

ORA-03222: average row size and row count must be greater than zero

Cause: Either a bad value passed to dbms_space.create_table_cost() or explain plan did not pass through size information.

Action: Check the row size parameter in dbms_space.create_table_cost(). For explain plan, make sure statistics have been computed for all source tables in the CREATE TABLE AS SELECT statement.

ORA-03223: Bitmap index block addressable limitation reached

Cause: The limitation of addressability of BMIB (Bitmap Index Block) was reached for the current blocksize.

Action: If the segment size has grown greater than addressability of BMIB (Bitmap Index Block), do the following: (1) Partition the table. (2) Move the segment to a tablespace having bigger blocksize.

ORA-03230: segment only contains string blocks of unused space above high water mark

Cause: Attempt to preserve too many blocks.

Action: reduce the KEEP amount.

ORA-03231: the INITIAL extent may not be deallocated

Cause: Attempt to deallocate space from the segment which was truncated prior to the 7.3 release.

Action: increase the KEEP amount, or truncate the segment, and reissue the command.

ORA-03233: unable to extend table string.string subpartition string by string in tablespace string

Cause: Failed to allocate an extent for table subpartition segment in tablespace.

Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.

ORA-03234: unable to extend index string.string subpartition string by string in tablespace string

Cause: Failed to allocate an extent for index subpartition segment in tablespace.

Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.

ORA-03235: max # extents (string) reached in table string.string subpartition string

Cause: A table subpartition tried to extend past maxextents

Action: If maxextents is less than the system maximum, raise it. Otherwise, you must recreate with larger initial, next or pctincrease params

ORA-03236: max # extents (string) reached in index string.string subpartition string

Cause: An index subpartition tried to extend past maxextents

Action: If maxextents is less than the system max, raise it. Otherwise, you must recreate with larger initial, next or pctincrease params.

ORA-03237: Initial Extent of specified size cannot be allocated in tablespace (string)

Cause: Too large a size for an initial extent due to freelist group specification

Action: Reduce number of freelist groups specified for segment

ORA-03238: unable to extend LOB segment string.string subpartition string by string in tablespace string

Cause: An attempt was made to allocate an extent for LOB subpartition segment in tablespace, but the extent could not be allocated because there is not enough space in the tablespace indicated.

Action: Use the ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.

ORA-03239: maxextents (string) reached in LOB segment string.string subpartition string

Cause: A LOB subpartition segment tried to extend past maxextents.

Action: If maxextents is less than the system maximum, raise it. Otherwise, recreate the subpartition with larger INITIAL, NEXT, or PCTINCREASE parameters.

ORA-03240: User's temporary tablespace same as tablespace being migrated

Cause: Users default temporary tablespace must be different from the tablespace being migrated.

Action: alter users default temporary tablespace to be different.

ORA-03241: Invalid unit size

Cause: User specified an invalid unit size for the tablespace

Action: Specify the correct unit size. To estimate unit size please refer to Oracle Server Administrator's Guide.

ORA-03242: Tablespace migration retried 500 times

Cause: For migration to complete, temporary segments should not be present in the tablespace at the time of migration.

Action: Avoid migrating the tablespace when there is heavy temporary segment creation going on as with object drops.

ORA-03243: destination dba overlaps with existing control information

Cause: Cannot overlap control information during relocation

Action: Please chose another destination address

ORA-03244: No free space found to place the control information

Cause: During migration of tablespace found no place to put the control information. If during bitmaps relocation, found no space at the specified destination.

Action: If during migration, add more space to the tablespace and retry migration. If during bitmaps relocation, specify a destination address where there is enough free space.

ORA-03245: Tablespace has to be dictionary managed, online and permanent to be able to migrate

Cause: Tablespace was not dictionary managed or online or permanent.

Action: Make sure the tablespace is online, permanent and dictionary managed

ORA-03246: Invalid block number specified

Cause: Control information cannot be placed at the specified dba either because the block number specified is beyond the file end or the file is not large enough to accomodate the control information at that location

Action: specify a correct block number

ORA-03247: Invalid block number specified

Cause: Relocation of bitmaps to the said destination will make the tablespace self descriptive

Action: Choose another destination dba.

ORA-03248: Too much of segment creation activity during migration

Cause: Temporary segments were attempted to be created during migration

Action: The error is signalled after retrying migration for 500 times. Run migration when there is less of segment creation activity is going on.

ORA-03249: Uniform size for auto segment space managed tablespace should have atleast string blocks

Cause: For the given blocksize, uniform size specified is insufficient

Action: Specify larger extent size and retry

ORA-03250: Cannot mark this segment corrupt

Cause: This segment cannot be marked corrupt because it contains data dictionary objects

Action: Check the segment information and reissue the command.

ORA-03251: Cannot issue this command on SYSTEM tablespace

Cause: It is not permitted to migrate SYSTEM tablespace from locally managed format to dictionary managed format or relocate bitmaps.

Action: Check the tablespace name and procedure name

ORA-03252: initial extent size not enough for LOB segment

Cause: Fatblock size of LOB segment is too big to fit into the initial extent.

Action: Specify a smaller fatblock size or create the LOB segment in other tablespaces with bigger initial extent size.

ORA-03254: unable to execute the sql in read only database

Cause: Unable to create a consistent snapshot of the object in a read only database. Transaction recovery must be performed before opening the database read only.

Action: Open the database read write, allow dead transaction recovery to complete and then open the database read only.

ORA-03261: the tablespace string has only one file

Cause: Dropping file from ts which has a single file extent.

Action: Cannot make a tablespace fileless

ORA-03262: the file is non-empty

Cause: Trying to drop a non-empty datafile

Action: Cannot drop a non empty datafile

ORA-03263: cannot drop the first file of tablespace string

Cause: Trying to drop the first datafile with which ts is created

Action: Cannot drop the first datafile with which ts is created

ORA-03264: cannot drop offline datafile of locally managed tablespace

Cause: Trying to drop offline datafile in lmts

Action: Try to drop file afetr making it online

ORA-03274: both ALLOCATE EXTENT and DEALLOCATE UNUSED options are specified

Cause: The DEALLOCATE option and the ALLOCATE option are specified in the same command.

Action: Choose one of the options or issue two separate commands.

ORA-03275: duplicate DEALLOCATE option specification

Cause: The DEALLOCATE UNUSED option to ALTER TABLE or ALTER INDEX is specified more than once.

Action: Specify the option at most once.

ORA-03276: duplicate ALLOCATE EXTENT option specification

Cause: The ALLOCATE EXTENT option to ALTER TABLE or ALTER INDEX is specified more than once.

Action: Specify the option at most once.

ORA-03277: invalid SIZE specified

Cause: The specified value must be an integer.

Action: Choose an appropriate integer value.

ORA-03278: duplicate ALLOCATE EXTENT option specification

Cause: An option (DATAFILE, SIZE or INSTANCE) was specified more than once.

Action: Specify each option at most once.

ORA-03279: invalid INSTANCE specified

Cause: The specified value is not recognized as a valid instance name.

Action: Use a valid name.

ORA-03280: invalid DATAFILE filename specified

Cause: A character string literal is expected, but not found.

Action: Specify filenames using character string literals.

ORA-03281: invalid ALLOCATE EXTENT option

Cause: An option other than DATAFILE, SIZE or INSTANCE was specified.

Action: Remove invalid option and retry the command.

ORA-03282: missing ALLOCATE EXTENT option

Cause: No ALLOCATE EXTENT options were specified.

Action: Specified one or more of the following options: DATAFILE, SIZE or INSTANCE.

ORA-03283: specified datafile string does not exist

Cause: The datafile does not exist

Action: Retry the option with the correct datafile

ORA-03284: datafile or tempfile string is not a member of tablespace string

Cause: The specified datafile or tempfile did not belong to the tablespace that the object resides in.

Action: Retry the option with the correct datafile or tempfile.

ORA-03286: ALLOCATE EXTENT not valid for HASH CLUSTERS

Cause: The cluster is a hash cluster, and can not use the allcoate extent option.

Action: n/a

ORA-03287: invalid FREELIST GROUP specified

Cause: The specified FREELIST GROUP number is invalid

Action: Choose a number between 1 and # freelist groups for this object

ORA-03288: both FREELIST GROUP and INSTANCE parameters may not be specified

Cause: Both FREELIST GROUP and INSTANCE were specified in clause

Action: Remove one of the two parameters

ORA-03289: partition name and segment type do not match

Cause: Partition name and segment type specified for space analysis do not match

Action: Specify type PARTITION if the object is partitioned, specify SUBPARTITION if the object is composite

ORA-03290: Invalid truncate command - missing CLUSTER or TABLE keyword

Cause: Invalid object specification given.

Action: Either specify TRUNCATE CLUSTER or TRUNCATE TABLE

ORA-03291: Invalid truncate option - missing STORAGE keyword

Cause: Expected STORAGE keyword

Action: Either specify DROP STORAGE or REUSE STORAGE

ORA-03292: Table to be truncated is part of a cluster

Cause: The table being truncated is a member of a cluster.

Action: Either use TRUNCATE CLUSTER or DROP TABLE

ORA-03293: Cluster to be truncated is a HASH CLUSTER

Cause: Only INDEX CLUSTERS can be truncated.

Action: Drop and recreate the HASH CLUSTER instead of using truncate.

ORA-03296: cannot resize datafile - file string not found

Cause: The specified datafile is not available for resizing.

Action: Ensure that the datafile name is valid, and if so, ensure the file is accessible.

ORA-03297: file contains used data beyond requested RESIZE value

Cause: Some portion of the file in the region to be trimmed is currently in use by a database object

Action: Drop or move segments containing extents in this region prior to resizing the file, or choose a resize value such that only free space is in the trimmed.

ORA-03298: cannot shrink datafile - file string is under hot backup

Cause: Attempt to shrink a datafile while it is under hot backup. This is not allowed.

Action: Retry shrinking the file after the hot backup completes.

ORA-03299: cannot create dictionary table string

Cause: A dictionary table is created upon the first execution of the command 'alter database datafile autoextend on' for a database. This operation did not succeed. The most probable cause for this is insufficient space in the system tablespace.

Action: See action for next error message in error stack.

ORA-04000: the sum of PCTUSED and PCTFREE cannot exceed 100

Cause: the sum of PCTUSED and PCTFREE for a cluster or table exceeds 100

Action: create the table/cluster specifying values whose sum is <= 100

ORA-04001: sequence parameter string must be an integer

Cause: %s (a sequence parameter) specified was not an integer

Action: create the sequence, giving the specified parameter an integer value

ORA-04002: INCREMENT must be a non-zero integer

Cause: a sequence increment was specified to be zero

Action: specify the increment to be a non-zero value

ORA-04003: sequence parameter string exceeds maximum size allowed (string digits)

Cause: %s (a sequencer parameter) had too many digits

Action: specify the parameter with the allowed number of digits

ORA-04004: MINVALUE must be less than MAXVALUE

Cause: MINVALUE was specified to be greater than or equal to MAXVALUE

Action: specify a MINVALUE that is less than MAXVALUE

ORA-04005: INCREMENT must be less than MAXVALUE minus MINVALUE

Cause: the INCREMENT specified is >= MAXVALUE-MINVALUE

Action: specify an INCREMENT that is < MAXVALUE-MINVALUE

ORA-04006: START WITH cannot be less than MINVALUE

Cause: the given starting value is less than MINVALUE

Action: make sure that the starting value is >= MINVALUE

ORA-04007: MINVALUE cannot be made to exceed the current value

Cause: the given MINVALUE would be greater than the current value

Action: always make sure that MINVALUE is <= the current value

ORA-04008: START WITH cannot be more than MAXVALUE

Cause: the starting value would be larger than MAXVALUE

Action: make sure that the starting value is less than MAXVALUE

ORA-04009: MAXVALUE cannot be made to be less than the current value

Cause: the current value exceeds the given MAXVALUE

Action: make sure that the new MAXVALUE is larger than the current value

ORA-04010: the number of values to CACHE must be greater than 1

Cause: the value in the CACHE clause was one

Action: specify NOCACHE, or a value larger than one

ORA-04011: sequence string must range between string and string

Cause: the value specified for one of the sequence parameters exceeds limits

Action: specify parameter within these limits

ORA-04012: object is not a sequence

Cause: the object specified cannot have sequence ddl's performed on it

Action: re-enter the statement being careful with the spelling of the name

ORA-04013: number to CACHE must be less than one cycle

Cause: number to CACHE given is larger than values in a cycle

Action: enlarge the cycle, or cache fewer values

ORA-04014: descending sequences that CYCLE must specify MINVALUE

Cause: sequences that cycle must have their wrap-wrap specified

Action: re-create the sequence, specifying its wrap-value

ORA-04015: ascending sequences that CYCLE must specify MAXVALUE

Cause: sequences that cycle must have their wrap-wrap specified

Action: re-create the sequence, specifying its wrap-value

ORA-04016: sequence string no longer exists

Cause: sequence was dropped while processing its next value.

Action: re-create the sequence

ORA-04017: invalid value string (length = string) for parameter MAX_DUMP_FILE_SIZE

Cause: The string supplied for the parameter MAX_DUMP_FILE_SIZE was not an integer, an integer followed by 'K', 'M', or 'G', nor the special value UNLIMITED.

Action: Provide a proper value for this parameter.

ORA-04020: deadlock detected while trying to lock object stringstringstringstringstring

Cause: While trying to lock a library object, a deadlock is detected.

Action: Retry the operation later.

ORA-04021: timeout occurred while waiting to lock object stringstringstringstringstring

Cause: While waiting to lock a library object, a timeout occurred.

Action: Retry the operation later.

ORA-04022: nowait requested, but had to wait to lock dictionary object

Cause: Had to wait to lock a library object during a nowait request.

Action: Retry the operation later.

ORA-04023: Object stringstringstringstringstring could not be validated or authorized

Cause: A number of attempts were made to validate or authorize an object but failed.

Action: Please report this error to Oracle Support Services.

ORA-04024: self-deadlock detected while trying to mutex pin cursor string

Cause: While trying to mutex pin a cursor, a self-deadlock is detected.

Action: Retry the operation later.

ORA-04025: maximum allowed library object lock allocated for stringstringstringstringstring

Cause: Too many active locks for the object has been allocated. This error can be a result of too many cursors kept open per session.

Action: Close cursors, reduce session_cached_cursors value.

ORA-04027: self-deadlock during automatic validation for object string.string

Cause: An attempt was made to validate an invalidated object but it failed because of a self-deadlock.

Action: Identify the root cause of the self-deadlock and take corrective action, e.g. compile the invalidated object separately.

ORA-04028: cannot generate diana for object stringstringstringstringstring

Cause: Cannot generate diana for an object because of lock conflict.

Action: Please report this error to your support representative.

ORA-04029: error ORA-string occurred when querying stringstringstring

Cause: The table or view being queried might be missing. The error number indicates the error.

Action: Fix the error.

ORA-04030: out of process memory when trying to allocate string bytes (string,string)

Cause: Operating system process private memory was exhausted.

Action: n/a

ORA-04031: unable to allocate string bytes of shared memory ("string","string","string","string")

Cause: More shared memory is needed than was allocated in the shared pool or Streams pool.

Action: If the shared pool is out of memory, either use the DBMS_SHARED_POOL package to pin large packages, reduce your use of shared memory, or increase the amount of available shared memory by increasing the value of the initialization parameters SHARED_POOL_RESERVED_SIZE and SHARED_POOL_SIZE. If the large pool is out of memory, increase the initialization parameter LARGE_POOL_SIZE. If the error is issued from an Oracle Streams or XStream process, increase the initialization parameter STREAMS_POOL_SIZE or increase the capture or apply parameter MAX_SGA_SIZE.

ORA-04032: pga_aggregate_target must be set before switching to auto mode

Cause: attempt to set workarea_size_policy to AUTO while pga_aggregate_target is not specified

Action: before setting workarea_size_policy, set pga_aggregate_target to a value representing the total private memory available to the instance. This total is generally the total physical memory available in the system minus what is needed for the SGA minus what is needed for the operating system (e.g. 500MB)

ORA-04033: Insufficient memory to grow pool

Cause: The system had insufficient memory to grow the pool to the specified size.

Action: Specify a smaller value to grow the pool.

ORA-04034: unable to shrink pool to specified size

Cause: The pool could not shrink to the specified size as it could not free memory.

Action: Specify a larger value to which to shrink the pool to.

ORA-04035: unable to allocate string bytes of shared memory in shared object cache "string" of size "string"

Cause: More shared memory is needed than was allocated in the shared object cache.

Action: n/a

ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT

Cause: Private memory across the instance exceeded the limit specified in the PGA_AGGREGATE_LIMIT initialization parameter. The largest sessions using Program Global Area (PGA) memory were interrupted to get under the limit.

Action: Increase the PGA_AGGREGATE_LIMIT initialization parameter or reduce memory usage.

ORA-04041: package specification must be created first before creating package body

Cause: Attempt to create a package body before creating its package specification.

Action: Create the package specification first before creating the package body.

ORA-04042: procedure, function, package, or package body does not exist

Cause: Attempt to access a procedure, function, package, or package body that does not exist.

Action: Make sure the name is correct.

ORA-04043: object string does not exist

Cause: An object name was specified that was not recognized by the system. There are several possible causes: - An invalid name for a table, view, sequence, procedure, function, package, or package body was entered. Since the system could not recognize the invalid name, it responded with the message that the named object does not exist. - An attempt was made to rename an index or a cluster, or some other object that cannot be renamed.

Action: Check the spelling of the named object and rerun the code. (Valid names of tables, views, functions, etc. can be listed by querying the data dictionary.)

ORA-04044: procedure, function, package, or type is not allowed here

Cause: A procedure, function, or package was specified in an inappropriate place in a statement.

Action: Make sure the name is correct or remove it.

ORA-04045: errors during recompilation/revalidation of string.string

Cause: This message indicates the object to which the following errors apply. The errors occurred during implicit recompilation/revalidation of the object.

Action: Check the following errors for more information, and make the necessary corrections to the object.

ORA-04046: results of compilation are too large to support

Cause: Attempt to compile and store a large stored procedure that results in compilation data that is too large for the system to support or store.

Action: Reduce the size of the store procedure by splitting it into smaller stored procedures.

ORA-04047: object specified is incompatible with the flag specified

Cause: The object type implied by the flag does not match the type of object specified.

Action: Specify the correct object, or use the appropriate flag

ORA-04050: invalid or missing procedure, function, or package name

Cause: The required procedure, function, or package name is invalid or missing.

Action: Specify a valid name.

ORA-04051: user string cannot use database link string.string

Cause: During forwarding of a remote object access, an attempt was made to use a non-existent database link or one owned by a user other than the logon user or PUBLIC.

Action: Change your database link structure so that all indirect remote accesses are done from the same userid that originates the request.

ORA-04052: error occurred when looking up remote object stringstringstringstringstring

Cause: An error occurred when trying to look up a remote object.

Action: Fix the error. Make sure the remote database system has run CATRPC.SQL to create necessary views used for querying or looking up objects stored in the database.

ORA-04053: error occurred when validating remote object stringstringstringstringstring

Cause: An error occurred when trying to validate a remote object.

Action: Fix the error. Make sure the remote database system has run CATRPC.SQL to create necessary views used for querying or looking up objects stored in the database.

ORA-04054: database link string does not exist

Cause: During compilation of a PL/SQL block, an attempt was made to use a non-existent database link.

Action: Either use a different database link or create the database link.

ORA-04055: Aborted: "string" formed a non-REF mutually-dependent cycle with "string".

Cause: This compilation was aborted because the library unit that was compiled would have formed a non-REF mutually-dependent cycle with some other library units. This happens when an attempt is made to compile types that have attributes of other types that may participate in a cycle with this type. Example: create type t1; create type t2 (a t1); create type t1 (a t2);

Action: Break the cycle (possibly by adding a REF or by using another type).

ORA-04060: insufficient privileges to execute string

Cause: Attempt to execute a stored procedure without sufficient privileges.

Action: Get necessary privileges.

ORA-04061: existing state of string has been invalidated

Cause: Attempt to resume the execution of a stored procedure using the existing state which has become invalid or inconsistent with the stored procedure because the procedure has been altered or dropped.

Action: Try again; this error should have caused the existing state of all packages to be re-initialized.

ORA-04062: string of string has been changed

Cause: Attempt to execute a stored procedure to serve an RPC stub which specifies a timestamp or signature that is different from the current timestamp/signature of the procedure.

Action: Recompile the caller in order to pick up the new timestamp.

ORA-04063: string has errors

Cause: Attempt to execute a stored procedure or use a view that has errors. For stored procedures, the problem could be syntax errors or references to other, non-existent procedures. For views, the problem could be a reference in the view's defining query to a non-existent table. Can also be a table which has references to non-existent or inaccessible types.

Action: Fix the errors and/or create referenced objects as necessary.

ORA-04064: not executed, invalidated string

Cause: Attempt to execute a stored procedure that has been invalidated.

Action: Recompile it.

ORA-04065: not executed, altered or dropped string

Cause: Attempt to execute a stored procedure that has been altered or dropped thus making it not callable from the calling procedure.

Action: Recompile its dependents.

ORA-04066: non-executable object, string

Cause: Attempt to execute a non-procedure.

Action: Make sure that a correct name is given.

ORA-04067: not executed, string does not exist

Cause: Attempt to execute a non-existent stored procedure.

Action: Make sure that a correct name is given.

ORA-04068: existing state of packagesstringstringstring has been discarded

Cause: One of errors 4060 - 4067 when attempt to execute a stored procedure.

Action: Try again after proper re-initialization of any application's state.

ORA-04069: cannot drop or replace a library with table dependents

Cause: An attempt was made to drop or replace a library that has dependents. There could be a table which depends on type which depends on the library being dropped.

Action: Drop all table(s) depending on the type, then retry.

ORA-04070: invalid trigger name

Cause: An invalid trigger name was specified.

Action: Verify that trigger name is not a reserved keyword.

ORA-04071: missing BEFORE, AFTER or INSTEAD OF keyword

Cause: The trigger statement is missing the BEFORE/AFTER/INSTEAD OF clause.

Action: Specify either BEFORE, AFTER or INSTEAD OF.

ORA-04072: invalid trigger type

Cause: An invalid trigger type was given.

Action: Specify either INSERT, UPDATE or DELETE.

ORA-04073: column list not valid for this trigger type

Cause: A column list was specified for a non-update trigger type.

Action: Remove the column list.

ORA-04074: invalid REFERENCING name

Cause: An invalid name was given in the referencing clause.

Action: Verify the referencing name is not a reserved word.

ORA-04075: invalid trigger action

Cause: An statement was given for the trigger action.

Action: Re-specify the trigger action.

ORA-04076: invalid NEW or OLD specification

Cause: An invalid NEW or OLD specification was given for a column.

Action: Re-specify the column using the correct NEW or OLD specification.

ORA-04077: WHEN clause cannot be used with table level triggers

Cause: The when clause can only be specified for row level triggers.

Action: Remove the when clause or specify for each row.

ORA-04078: OLD and NEW values cannot be identical

Cause: The referencing clause specifies identical values for NEW and OLD.

Action: Re-specify either the OLD or NEW referencing value.

ORA-04079: invalid trigger specification

Cause: The create TRIGGER statement is invalid.

Action: Check the statement for correct syntax.

ORA-04080: trigger 'string' does not exist

Cause: The TRIGGER name is invalid.

Action: Check the trigger name.

ORA-04081: trigger 'string' already exists

Cause: The TRIGGER name or type already exists.

Action: Use a different trigger name or drop the trigger which is of the same name.

ORA-04082: NEW or OLD references not allowed in table level triggers

Cause: The trigger is accessing "new" or "old" values in a table trigger.

Action: Remove any new or old references.

ORA-04083: invalid trigger variable 'string'

Cause: The variable referenced in the trigger body is invalid.

Action: See the manual for valid trigger variable types.

ORA-04084: cannot change NEW values for this trigger type

Cause: New trigger variables can only be changed in before row insert or update triggers.

Action: Change the trigger type or remove the variable reference.

ORA-04085: cannot change the value of an OLD reference variable

Cause: Old values can only be read and not changed.

Action: Do not attempt to change an old variable.

ORA-04086: trigger description too long, move comments into triggering code

Cause: The trigger description is limited to 2000 characters (for dictionary storage reasons). The description does not include the text of the "when" clause or the text of the pl/sql code executed for the trigger.

Action: If the trigger description contains a large comment, move that

ORA-04087: cannot change the value of ROWID reference variable

Cause: Rowid's can only be read and not changed.

Action: Do not attempt to change an rowid value.

ORA-04088: error during execution of trigger 'string.string'

Cause: A runtime error occurred during execution of a trigger.

Action: Check the triggers which were involved in the operation.

ORA-04089: cannot create triggers on objects owned by SYS

Cause: An attempt was made to create a trigger on an object owned by SYS.

Action: Do not create triggers on objects owned by SYS.

ORA-04090: 'string' specifies same table, event and trigger time as 'string'

Cause: Trigger is of duplicate event and trigger time.

Action: Combine the triggering information into one trigger which is fired at the given time.

ORA-04091: table string.string is mutating, trigger/function may not see it

Cause: A trigger (or a user defined plsql function that is referenced in this statement) attempted to look at (or modify) a table that was in the middle of being modified by the statement which fired it.

Action: Rewrite the trigger (or function) so it does not read that table.

ORA-04092: cannot string in a trigger

Cause: A trigger attempted to commit or rollback.

Action: Rewrite the trigger so it does not commit or rollback.

ORA-04093: references to columns of type LONG are not allowed in triggers

Cause: A trigger attempted to reference a long column in the triggering table.

Action: Do not reference the long column.

ORA-04094: table string.string is constraining, trigger may not modify it

Cause: A trigger attempted to modify a table that was constraining for some referential constraint of a parent SQL statement.

Action: n/a

ORA-04095: trigger 'string' already exists on another table, cannot replace it

Cause: Cannot replace a trigger which already exists on a different table than the one being replaced.

Action: Drop the trigger with the same name and re-create it.

ORA-04096: trigger 'string' has a WHEN clause which is too large, limit 2K

Cause: A trigger's 'when' clause is limited to 2K for dictionary storage reasons. The trigger being created exceeded that size.

Action: Use a smaller 'when' clause. Note, the trigger body could be used to perform the same limiting action as the 'when' clause.

ORA-04097: DDL conflict while trying to drop or alter a trigger

Cause: An attempt was made to concurrently perform two DDL operations on a trigger or trigger table.

Action: Investigate the new state of the trigger and retry the DDL operation, if still appropriate.

ORA-04098: trigger 'string.string' is invalid and failed re-validation

Cause: A trigger was attempted to be retrieved for execution and was found to be invalid. This also means that compilation/authorization failed for the trigger.

Action: Options are to resolve the compilation/authorization errors, disable the trigger, or drop the trigger.

ORA-04099: trigger 'string' is valid but not stored in compiled form

Cause: A trigger was attempted to be retrieved for execution and was found to be valid, but not stored. This may mean the an upgrade was done improperly from a non-stored trigger release.

Action: Alter compile the trigger to create the trigger in stored form. Also, you may want to review that a proper upgrade was done.