Re: Altering Rollback Segments Offline

A couple of things come to mind:

1. Are you sure you're using the pfile that you just edited?
2. In addition to taking the rbs's offline, go ahead and drop them (after they go offline normal). That way they can't possibly reappear after you bounce the instance. If you're hitting the wrong pfile somehow, you will get some errors in the alert log.
3. It's not inconceivable that you have an Oracle version with some really odd bug. If this continues, call Oracle Support and have them search for any bugs on this topic for your version.

Good luck,
Dave

stuco_at_mailcity.com wrote in message <6m3phi$3un$1_at_nnrp1.dejanews.com>...
>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
Received on Mon Jun 15 1998 - 21:10:16 CDT