Re: Help with Rollback Segment Cannot be Extended workaround.

[Quoted] [Quoted] 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 [Quoted] generation for the duration of the instance.

I haven't a clue what other side effects it might produce, and I don't vouch [Quoted] 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 [Quoted] 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