Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-02291: integrity constraint violated - parent key not found

591309Oct 21 2008 — edited Oct 21 2008
Hi 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?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 18 2008
Added on Oct 21 2008
9 comments
11,094 views