Re: spfile

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Fri, 5 Nov 2004 12:04:32 +1100
Message-ID: <418ad185$0$24942$afc38c87@news.optusnet.com.au>

"Oradba Linux" <techiey2k3_at_comcast.net> wrote in message news:1bAid.46596$HA.33011_at_attbi_s01...
> Using spfile and old fashioned rollback segments, once a bunch of new
> rollback segments are added how do you update the spfile
> so that they are online next time you recycle the database

It ought to be something like

alter system set rollback_segments='RBS01, RBS02, RBS03, RBS04' scope=spfile;

...ie, just a comma-separated list of segments.

But it is so long since I used rollback segments rather than undo, I don't actually have a system I can test that on easily. So it might not be that at all!

Just curious: why wouldn't you want to use automatic undo?

Regards
HJR Received on Thu Nov 04 2004 - 19:04:32 CST