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

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-02296: cannot enable (string.string) - null values found

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-02295: found more than one enable or disable clause for constraint

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

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

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

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

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-02293: cannot validate (string.string) - check constraint violated

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-02292: integrity constraint (string.string) violated - child record found

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-02291: integrity constraint (string.string) violated - parent key not found

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.