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!

deletion sequence - violate foreign key child record found

helooOct 20 2019 — edited Oct 21 2019

when i delete records in many table, it always trigger violate the foreign key - child record found, this error casuing me can't delete all the related record in the schema by Oracle sqlplus.

how can i find all the related table's foreign key to delete the related record so i can delete the record successfully? any script in convinence way to check all the related record and any script to find out the record deletion sequence?

Comments
Post Details
Added on Oct 20 2019
6 comments
2,713 views