Re: need to delete 37000000 rows

I noticed I left the commit out right after I sent that but I knew the poster would know what I meant. Obviously, you need to commit after each batch.

Richard

Nicolas Bronke wrote:
>
> > Why can't you just do something like this to delete 10,000 (or whatever)
> > at a time:
> >
> > loop
> >
> > delete table_x
> > where ...
> > and rownum <= 10000;
> >
> > exit when sql%rowcount = 0;
> >
> > end loop;
> >
> And where are the advantage against deleting all records with one command if
> there is no commit between?
>
> Regards
> Nicolas
Received on Sun Nov 04 2001 - 11:59:05 CST