Re: Delete a BIG table.

Kenneth Foo wrote:
>
> Hi,
>
> Dose anybody know how to disable the ROLLBACK when you delete a BIG table ( I
> don't want to drop it) rather than giving you the error message
>
> Unable to extent rollback segment ......
>
> and I hope I can leave the existing rollback segment structure intact because
> this is only a temporally deleting a big table and I am pretty sure I don't
> need it to be rollbacked.
>
> Thanks for any help.
>
> Ken
> Cheers

Note that truncate only works on the WHOLE table - if you want to delete part of the table but this still is a lot of data, then you can do it in "chunks" using PL/SQL eg

while true
  delete from table
  where ...
  and rownum < 1000;
  if sql%ROWCOUNT = 1000 then
   commit;
  else
   exit;
  end if;
end loop;
commit;

Cheers

-- 
Connor McDonald
Systems Administrator-Unix/Oracle
BHP Iron Ore
"You're not drunk if you can lie on the floor without holding on"
            - Dean Martin