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;

Richard Received on Sat Nov 03 2001 - 20:15:55 CST