Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Keeping rollback segments online?

Re: Keeping rollback segments online?

From: mohdzaid <mohdzaid_at_pacific.net.sg>
Date: Wed, 22 Jul 1998 12:13:29 +0800
Message-ID: <6p3oth$mt5$1@nobel.pacific.net.sg>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US