Oracle Database Errors or Warnings from Error ORA-02291 to ORA-02300

SQLServerF1

 

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.

Above are list of Oracle Database Errors or Warnings from Error ORA-02291 to ORA-02300 received while performing certain operation against Oracle Database or related products.

What are Oracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database.  Each Oracle Database Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.

Hope this was helpful.

Thanks,
SQLServerF1 Team
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.

 

Leave a Reply

Your email address will not be published. Required fields are marked *