ORA-02298 cannot validate parent keys

I got ” ORA-02298 cannot validate parent keys ” error in Oracle database.

 

ORA-02298 cannot validate parent keys

 

Details of error are as follows.

ORA-02298 cannot validate parent keys

Cause: an alter table validating constraint failed because the table has child records.

Action: Obvious

 

 

cannot validate parent keys

This ORA-02298 errors are related with the constraint failed because the table has child records.

To solve this error, you need to delete the child records from the child table, then try again.

Or you need to insert the missing records to the parent table, then try again.

This problem is related with the parent – child ( foreign key relationship )

 

 

Do you want to learn Oracle Database for Beginners, then read the following articles.

Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )