ORA-02430: cannot enable constraint
Oracle PL/SQL error message: ORA-02430: cannot enable constraint.
Cause:
The named constraint does not exist for this table.
Solution:
Check that a constraint exists before trying to enable it.
Example:
ALTER TABLE test ENABLE CONSTRAINT constraint_name;
Output:
ORA-02430: cannot enable constraint
Check constraint
SELECT OWNER, CONSTRAINT_NAME, STATUS FROM user_constraints WHERE table_name = 'TEST';