Re: Help with Rollback Segment Cannot be Extended workaround.

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 19 May 2001 09:54:11 +0100
Message-ID: <990262356.544.0.nnrp-12.9e984b29_at_news.demon.co.uk>


Are you sure this will do anything useful - When I were a lad, discrete_transactions were restricted to 'small transactions', with the strict limit that you could not revisit a block you had changed during the course
of the transaction - which meant that
even parent/child inserts wouldn't work
because the FK check would not be
allowed to visit the parent blocks.

Also, you had to invoke discrete transactions through a call to a PL/SQL procedure.

I haven't looked at them for years, so I won't fell hurt if the pair of you tell me I've got it all wrong.

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

Practical Oracle 8i:  Building Efficient Databases
Publishers:  Addison-Wesley

Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



Daniel A. Morgan wrote in message <3B0625CD.A4BF5002_at_exesolutions.com>...

>"Howard J. Rogers" wrote:
>
>> If this is truly a one-off, and you don't care about the ability to
>> rollback, then you can employ a hidden parameter which switches off
rollback
>> generation for the duration of the instance.
>>
>> I haven't a clue what other side effects it might produce, and I don't
vouch
>> for the stability of your database whilst you do it. It's totally
>> unsupported by Oracle, and you are ENTIRELY ON YOUR OWN!!!
>>
>> (Have I scared you enough yet? I should have... take this step only if
you
>> have a bloody good backup)
>>
>> In your init.ora, enter the following line:
>> _discrete_transactions_enabled=TRUE. Then bounce your Instance.
>>
>> That switches off all rollback activity on the entire database.
>>
>> Regards
>> HJR
>>
>> --
>> =============================!!=============================
>> The views expressed are my own only, and definitely NOT those of Oracle
>> Corporation
>> =============================!!=============================
>>
>> "Anon" <empty_at_noone.com> wrote in message
>> news:nqg7gt8jds0h49t82lnmls0gq4qnmlblhn_at_4ax.com...
>> > I have a large script to run that updates data in many rows. I get
>> > the error that the rollback segment cannot be exteneded.
>> > Does anyone know how to get around this?
>> > Is there a way to have the changes comitted automatically so no
>> > rollback segment is needed?
>> >
>> > The easy way would be to make the rollback segments auto-extend to an
>> > unlimited size. I am at a customers site and making changes to the
>> > production system is very difficult and I only need it for this one
>> > operation.
>> > Oracle seems to be running OK with no problems. I just need to make
>> > this one-time data conversion and I will be finished. I am curently
>> > running the script from Sql Plus and the database is Oracle 8.0.5.
>> >
>> > Don
>
>Glad you scared him and hopefully others. It is a parameter that solves an
>easily rectified problem by creating a potential disaster.
>
>Sort of like treating a splinter by amputation.
>
>But you are correct ... it will perform the amputation.
>
>Daniel A. Morgan
>
Received on Sat May 19 2001 - 10:54:11 CEST

Original text of this message