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

You can use truncate command. It does not use rollback segment.

Arthur

Tina Tran <tinat_at_sonica.com> napisa³(a) w artykule <01bcf089$e3409ea0$2aaeb6cc_at_dino>...
> 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 Fri Nov 14 1997 - 00:00:00 CST