Home Privacy Policy Feedback Link to us Site Map

Oracle/PLSQL: ORA-02298 Error


Error:

ORA-02298: cannot enable name - parent keys not found

Cause:

You tried to execute an ALTER TABLE ENABLE CONSTRAINT command, but it failed because your table has orphaned child records in it.

Action:

The options to resolve this Oracle error are:
  1. Remove the orphaned child records from the child table (foreign key relationship), and then re-execute the ALTER TABLE ENABLE CONSTRAINT command.
  2. Create the missing parent records in the parent table (foreign key relationship), and then re-execute the ALTER TABLE ENABLE CONSTRAINT command.

Learn more about foreign keys.