ORA-02430: cannot enable constraint

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';