Re: Rollback segments offline on database restart

confirm that you have the 25 rollback segments listed in your init.ora file.

example:

rollback_segments = (r01,r02,r03,r04)

>
> Hello,
> I have created 25 rollback segments. Now whenever i restart the database few
> rollback segments are offline. To one procedure i have assigened one
> rollback segment with the help of 'set transaction use ....'. Now whenever
> the database is restarted around 5-7 rollback segments are offline, which i
> manually have to set it online again. How to get this thing done. Do i have
> to use rollback_segments parameter and list out all(more than 25) segments
> there?
> Please help.
> Ravi.
>
> ________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
> --
> Author: Ravi Babu
> INET: lravibabu_at_hotmail.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Tue Jul 11 2000 - 09:36:46 CDT