Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: deleting large number of records from table...
Commit more often! You can create a cursor, delete 1000 records at a time, commit...
bill <beers_at_mindspring.com> wrote in article
<647a9c$s51_at_camel12.mindspring.com>...
> 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 Thu Nov 13 1997 - 00:00:00 CST