ORA-02298 Parent Keys Not Found

After you export DB then import it you may get this error:

That means a value found in child table but not found in parent table.



You can solve it by the following script to get the values not found :



select <COLUMN_NAME> from <CHILD_TABLE> a where not exists (select <COLUMN_NAME> from



<PARENT_TABLE> where primary_key = a.<KEY_VALUE>);





To looks like :

Then you will get different values and insert them into parent table  or delete them from child table.

Thanks to Atlassian Documentation