SQL & PL/SQL

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!

DELETE records from table having foreign key reference

656751Sep 19 2008 — edited Sep 22 2008

Hi,

I have the below requirement. I want to DELETE records from a table which is having a number of foreign key references( total 48). I have deleted the child records, but when deleting from the parent it takes a long time as it's checking all the foreign keys. Can anyone suggest how to improv the performance of this? Is there any possibility to disable all foreign keys

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 20 2008

Added on Sep 19 2008

10 comments

2,407 views