Skip to Main Content
Forums

Oracle Database Discussions

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!

Deleting records taking too long

1057682Apr 2 2015 — edited Apr 6 2015

I am  using Oracle 12c.

I am trying to delete about 6mil records from a table that has about 18mil records.

Below is the query I am using. I cancel the process after 2hrs. I have let the process go over night and still nothing.

DELETE FROM EI.CASESTATUS

     WHERE CASEID NOT IN (SELECT CASEID FROM DO.STG_CASEHEADER);

Is there a faster way of doing this?



Thanks for your help,

Kevin
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 4 2015
Added on Apr 2 2015
#delete, #general-database-discussions
17 comments
34,881 views