Re: How to disable rollback

From: <junlei_at_my-deja.com>
Date: Thu, 28 Oct 1999 18:54:29 GMT
Message-ID: <7va653$98p$1@nnrp1.deja.com>

Create another rollback segment with much larger extents to handle the problem. Afterwards, you can delete it or take it off line.

Junlei

In article <3816EE15.DDEB302D_at_dnm.it>,
Boris Bliznukov <blib_at_dnm.it> 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
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Oct 28 1999 - 13:54:29 CDT