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: <larionov_at_yahoo.com>
Date: Mon, 20 Jul 1998 22:02:58 GMT
Message-ID: <6p0eqi$qtr$1@nnrp1.dejanews.com>


How about your init.ora file?
Is there the initialization parameter: rollback_segments?

Misha.

In article <6p09s7$jot$1_at_nnrp1.dejanews.com>,   meyer_b_at_my-dejanews.com wrote:
> 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
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Mon Jul 20 1998 - 17:02:58 CDT

Original text of this message

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