Re: Keeping rollback segments online?

From: Boris V Izotoff <ibw_at_imail.dc.ukrtel.net>
Date: Tue, 21 Jul 1998 15:37:44 +0300
Message-ID: <6p2jlr$ghg$1@mg.dc.ukrtel.net>

meyer_b_at_my-dejanews.com ÐÉÛÅÔ × ÓÏÏÂÝÅÎÉÉ <6p09s7$jot$1_at_nnrp1.dejanews.com> ...
...
>My problem is that whenever I shut down the database and restart it, the
>rollback segments don't come back online by themselves. I have to issue an
>Alter statement to get them back online.
>
>How can I make this happen automatically?

Add to initialization file init<SID>.ora string

rollback_segemtns = rb01, rb02, rb03

where rb01,... - names of your rollback segments

>Bob M.
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Tue Jul 21 1998 - 07:37:44 CDT