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!

Deleting records in batches.

2726057Dec 2 2014 — edited Dec 4 2014

Hi,

Can any one please assist me on the below requirement:

There are 15mn records in a table and we need to delete them in batches of 10k.So as to reduce the load in database.

The query should be in Cursor or procedure and it should display like Deleted Record 10000, deleted records 20000....

and again it should commit after every 10k records not for each record.

Any info on this would be grateful.

Thanks & Regards,

Sameet Kumar Patro

sameet.patro@gmail.com

This post has been answered by Anton Scheffer on Dec 2 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 30 2014

Added on Dec 2 2014

12 comments

7,613 views