Re: need to delete 37000000 rows

> 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 - 06:40:08 CST