Message-Id: <10555.111663@fatcity.com> From: Roy Ferguson Date: Tue, 11 Jul 2000 07:36:46 -0700 Subject: Re: Rollback segments offline on database restart confirm that you have the 25 rollback segments listed in your init.ora file. example: rollback_segments = (r01,r02,r03,r04) > > 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 > > -- > Author: Ravi Babu > INET: lravibabu@hotmail.com > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing).