Export the rows you want to keep and then do a LOAD Replace.
Originally posted by David2002
I am trying to delete 600000 rows of a table with 10000000 records, I used "delete" command It took long more than 6 hrs, is there alternative way to do that faster.
Another way can be to create a table similar to the orginal with NOT LOGGED INITIALLY option and do a INSERT into newtab select * from orgtable <where-clause> , drop the original table and rename the newtable.
Or do a row-by-row delete using a cursor and commit every 'n' rows ..
mmm ... Good luck ...
Originally posted by Balr14
Select and reload 9.4m rows??? That's going to take some time and cause disruptions. What is current commit ratio and who else is using the table?