Rollback segments offline on database restart

From: Ravi Babu <lravibabu_at_hotmail.com>
Date: Tue, 11 Jul 2000 05:38:05 PDT
Message-Id: <10555.111652@fatcity.com>

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 Received on Tue Jul 11 2000 - 07:38:05 CDT