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

From: Ivars Grinbergs <ivarsg_at_itsystems.lv>
Date: 1997/11/11
Message-ID: <3468236F.5E535E25@itsystems.lv>#1/1

I prefere PL/SQL:

declare

   c number := 0;
begin

   for r in (select rowid from <my_table>) loop

      delete <my_table> where rowid=r.rowid;
      c := c+1;
      if mod(c,<count-portion>)=0 then commit; end if;

   end loop;
end;
/

bill wrote:

> 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