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 in parent table without checking for child records

girishkulkarniDec 21 2014 — edited Dec 22 2014

In a parent / child table scenario, I have deleted all the child records. When I try to delete parent records, it tries to check if the child records exists. Is there a way to skip the child records validation without disabling the constraints in child table?

This would help in cleanup of the table records without taking a downtime in PROD databases.

Warm Regards,

Girish Kulkarni

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 19 2015

Added on Dec 21 2014

4 comments

1,799 views