Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Keeping rollback segments online?
You may want to edit the init.ora file and insert the following:-
rollback_segments = (rbs01,rbs02,rbs03)
The names will depend on your settings.
Regards,
Zaid
Siemens Medical Instruments
meyer_b_at_my-dejanews.com wrote in message
<6p09s7$jot$1_at_nnrp1.dejanews.com>...
>I just created a new database under NT Workgroup Server 7.3.3. As part of
the
>process, I created a rollback tablespace with 3 rollback segments (nothing
>earth-shattering, I know), and altered them online.
>
>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?
>
>Thanks much for helping this poor, overwhelmed Oracle developer who's
quickly
>being turned into a half trained DBA <g>.
>
>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 - 23:13:29 CDT
![]() |
![]() |