Re: How to disable rollback

From: Eugene Firyago <efiryago_at_bisys.com>
Date: Thu, 28 Oct 1999 10:28:28 -0400
Message-ID: <7v9mj9$jg3$1@autumn.news.rcn.net>

Boris,

Consider the table reload using sql loader with direct load path wich avoids rollbacks.

Good luck,
Eugene.

Boris Bliznukov <blib_at_dnm.it> wrote in message news:3816EE15.DDEB302D_at_dnm.it...
> 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
Received on Thu Oct 28 1999 - 09:28:28 CDT