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!

How to delete from circular referencing tables

User_DDTKZOct 30 2013 — edited Oct 31 2013

Hi recently I am facing a strange situation while performing delete operations.

When I delete some rows from parent table: employees; (1) I got the error: ORA-02292: integrity constraint (HR.DEPT_MGR_FK) violated - child record found.

And I tried to delete corresponding rows from the child table: departments (so that I can delete rows from employees) (2) again I got the error: ORA-02292: integrity constraint (HR.EMP_DEPT_FK) violated - child record found

Now how to perform the delete operation, when there is a circular reference like this?

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 28 2013

Added on Oct 30 2013

#general-database-discussions

4 comments

1,525 views