ORA-02291: integrity constraint violated - parent key not found
591309Oct 21 2008 — edited Oct 21 2008Hi all,
I have two tables
A,B
A has primary key referenced as foreign key in B table
When I need to dleete some rows from table A.But when i tried to delete them,Iwas thrown with the error.
ORA-02292: integrity constraint (string.string) violated - child record found
So idisble the constraint from table B.
AFter that i delete the rows from table A and reserted some other rows.
But now when i try to enable the constraint,I am getting this error.
ORA-02291: integrity constraint (string.string) violated - parent key not found.
How to overcome this situation?