Skip to Main Content

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!

Any way to bypass Foreign Key Constraint

WilhelmSep 5 2007 — edited Sep 7 2007
I am trying to delete a row from a table(parent table) which is being referenced by more than 30 tables. All the Foreign keys in these Child tables are created without ON DELETE CASCADE . So i get 'child record found' erro when i try to delete a row from the parent table. Is there a way to bypass this and Delete a record in the parent table?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 5 2007
Added on Sep 5 2007
24 comments
6,284 views