Keeping rollback segments online?

From: <meyer_b_at_my-dejanews.com>
Date: Mon, 20 Jul 1998 20:38:31 GMT
Message-ID: <6p09s7$jot$1@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 Mon Jul 20 1998 - 15:38:31 CDT