Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Delete a BIG table.
Kenneth:
Is there some reason you cannot use the "truncate table table_name;" command. This command removes all rows from the table without firing triggers or creating redo logs. Careful since there is no redo log you cannot rollback a truncate. A truncate operates in less than a second where a delete for a BIG table might take hours.
Hope this helps,
John Hough
NCI Information Systems, Inc.
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
Received on Fri Feb 14 1997 - 00:00:00 CST