Re: deleting large number of records from table...

Another way which has not been suggested but I have heard suggested in an Oracle book and used successfully:

Create one large rollback segment. Use the 'set transaction' command to use that rollback segment for your large transaction. All other transactions will use all rollback segments in the typical round-robin fashion. This way you can have many rollback segments but only need one large one.

syntax is something like:
set transaction use BigRollbackSegment;
delete from table1;
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 Tue Nov 11 1997 - 00:00:00 CST