Originally posted by dba_admin
I have a table with 80 million rows of data. I need to delete about 40 millions. I can do either

1. set a huge rollback segment and delete 40millions at once
Faster but unreliable.


2. run a procedure and delete 10000 rows at a time
Slow but reliable.

HTH