Re: Altering Rollback Segments Offline

From: <shreterh_at_my-dejanews.com>
Date: Sun, 21 Jun 1998 05:07:32 GMT
Message-ID: <6mi4ek$729$1@nnrp1.dejanews.com>

If it's UNIX,: perhaps you have a linked copy in $ORACLE_HOME/dbs? (cp initXXX.ora $ORACLE_HOME/dbs; ln -f initXXX.ora $ORACLE_HOME/dbs/initXXX.ora)

In article <6m3phi$3un$1_at_nnrp1.dejanews.com>, stuco_at_mailcity.com wrote:
>
> I have 16 rollback segments, but only need 5 of them.
> When I alter segments 6-16 using 'ALTER ROLLBACK SEGMENT RB# OFFLINE;', I
> verify the init*.ora to make sure that only segments 1-5 are listed.
>
> Then I shutdown the instance, start it back up using the newly modified pfile.
>
> BUT...... all 16 are back ONLINE!
>
> Why does this happen and how can I alter them permenantly OFFLINE.
>
> Thanking you in advance for all your help!
>
> Stuart Cowen
> Paladin Consulting - Dallas
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Sun Jun 21 1998 - 00:07:32 CDT