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 )