Re: How to disable rollback

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 30 Oct 1999 13:45:22 -0000
Message-ID: <941293249.16673.0.nnrp-08.9e984b29@news.demon.co.uk>

You cannot disable the rollback.
Optimum solution depends on your version of Oracle, and your need for availability and resilience.

Have a look at my website for an article on updating large tables by generating rowid ranges; this may help.

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Boris Bliznukov wrote in message <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 Sat Oct 30 1999 - 08:45:22 CDT