Re: [Q/H]: Large Deletes

Neil Greene (neil_at_kynug.org) wrote:
: Some time ago, someone posted some messages regarding large deletes. I
: need to delete/purge about 60,000 records from a table containing about
: 700,000 records. What is the most efficient way to accomplish this
: without altering extents and tablespaces?

yep, that was I - this is the best I could do....

         LOOP
           delete table_eg
            where rownum < 500;    -- number of rows you wish <<<<<
           exit when sql%notfound;
           commit;
         END LOOP;

obviously add something to the where clause to select the 60,000 you want :)
I chose 500 based on our rollback segments - which is why I could not delete large number of rows to start with.

--
Steve Corbett.                    vvv
                                 [. .]   "just one person's opinion"
p0070623_at_brookes.ac.uk -------o00-(_)-00o---------