Re: How to disable rollback

From: Chandra Pabba <Chandra.Pabba_at_sabre.com>
Date: Wed, 27 Oct 1999 10:04:34 -0400
Message-ID: <38170671.F3719DA@sabre.com>

Boris Bliznukov wrote:

> Hi All!
>
> Is there any way to disable rollback?
>
> I have a table with ~ 3M rows and ~ 2G size and I want to delete about
> 1M rows at once ... Rollback segment was overflowing so I extend it :)
> ... now delete is running for straight 4 hours ... no luck so far ...
>
> Is it possible at all?
>
> --
> *** "I think there is a world market for maybe five computers."
> *** Thomas Watson, chairman of IBM, 1943

Hi!

There is no way to disable the rollback in respect of the transactions, which generate rollback by default. As such, you may like to use the TRUNCATE option, if you would like to delete all the rows, wherein no rollback is generated.

Thanks

Chandra Received on Wed Oct 27 1999 - 09:04:34 CDT