Re: Help with Rollback Segment Cannot be Extended workaround.

Daniel... Honestly! What the hell would you know about it? According to you, we don't even have SYSTEM rollback segments in Oracle 8.1.7. Yet, since we demonstrably do, your advice on this, as on so much else, is hugely suspect.

The parameter does what I said it would do, with the provisos I added. Anything else, coming from you especially, is meaningless and superfluous.

HJR

--
=============================!!=============================
The views expressed are my own only, and definitely NOT those of Oracle
Corporation
=============================!!=============================


"Daniel A. Morgan" <dmorgan_at_exesolutions.com> wrote in message
news: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

>