Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> deleting large number of records from table...
Could anyone give advice for deleting a large number of records from a table. I am trying to remove about 1,500,000 records and I am running out of rollback space. Would it be better to create a duplicate table structure and copy the few records to it, then drop the first table?
Thanks in advance for any help.
Bill
Received on Mon Nov 10 1997 - 00:00:00 CST