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!

Delete millions of records

Neo-bNov 24 2012 — edited Nov 25 2012

Hello All,

I am using Oracle 11g R2 (11.2.0.3).

On daily basis I am purging five millions records from a table.

What is the best solution to delete this huge number of records?
Is by single delete statement? or by for loop on all the records?
Which one is faster? the disadvantage of the single delete that it is consuming my undo tablespace.

Please advise.

Regards,

This post has been answered by JohnWatson on Nov 25 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 23 2012

Added on Nov 24 2012

#general-database-discussions

21 comments

16,961 views