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

No comments: