Skip to Main Content
Forums

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 child/parent table

sarvanAug 29 2011 — edited Aug 29 2011
Whenever we try to delete records in a parent table that has references in one or more child tables, it will throw an exception,

ORA-02292: integrity constraint (SCHEMA.TABLE_FK1) violated - child record found

I have a requirement in which I will delete records from Parent table and it has to delete records from the corresponding child tables without raising the above said exception

database : Oracle 11g
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 26 2011
Added on Aug 29 2011
9 comments
31,503 views