Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Delete a BIG table.
Try using the truncate table command
Kenneth Foo <kfo_at_orsil.ubc.ca> wrote in article
<5e26gp$7tm$1_at_nntp.ucs.ubc.ca>...
> 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.
Received on Fri Feb 14 1997 - 00:00:00 CST