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 dependents. There could be a substitutable column of a supertype of the type being dropped.
Action: Drop all type(s) and table(s) depending on the type, then retry the operation using the VALIDATE option, or use 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: None
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
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
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
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 string
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
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
Cause: The header may be corrupted.
Action: Contact Oracle Support Services.
ORA-02358: error in exporting or importing data
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
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
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
Cause: d by insufficient memory.
Action: Reconnect to the instance and retry the operation.
ORA-02362: error closing file: string
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
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
Cause: An attempt to write to 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
ORA-02365: error seeking in file: string
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
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
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
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
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
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
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-02379: profile string already exists
Cause: Try to create a profile which already exist
Action: None
ORA-02380: profile string does not exist
Cause: Try to assign a user to a non-existant profile
Action: None
ORA-02381: cannot drop PUBLIC_DEFAULT profile
Cause: Try to drop PUBLIC_DEFAULT profile
Action: None
ORA-02383: illegal cost factor
Cause: Negative or UNLIMITED cost for this resourc
Action: None
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-02396: exceeded maximum idle time, please connect again
Cause: as stated
Action: None
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: None
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.
No hay comentarios:
Publicar un comentario