From: "Howard J. Rogers" Newsgroups: comp.databases.oracle.misc References: Subject: Re: Oracle Rollback Segments Offline Lines: 40 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Original-NNTP-Posting-Host: 203.134.7.130 Message-ID: <39bae14c@news.iprimus.com.au> X-Original-Trace: 10 Sep 2000 12:18:04 +1100, 203.134.7.130 Date: Sun, 10 Sep 2000 12:19:22 +1000 NNTP-Posting-Host: 203.134.64.67 X-Trace: news0.optus.net.au 968548689 203.134.64.67 (Sun, 10 Sep 2000 12:18:09 EST) NNTP-Posting-Date: Sun, 10 Sep 2000 12:18:09 EST Organization: Another Optus Customer If they're private to the Instance, edit your init.ora. Put a line in that reads: rollback_segments=(x,y,z,a,b,c etc etc) -ie, name those segments in a comma-separated list in the init.ora, and the named ones come on-line automatically at start-up (assuming, however, that the rollback *tablespace* is on-line -otherwise, startup will fail as Oracle fails to find the named segments inside offline tablespace). Regards HJR -- -------------------------------------------------------------------------- Opinions expressed are my own, and not those of Oracle Corporation Oracle DBA Resources: http://www.geocities.com/howardjr2000 -------------------------------------------------------------------------- "Susan Entwisle" wrote in message news:VOyu5.12968$cr3.353602@ozemail.com.au... > Hi, > > I have created two additional rollback segments for an Oracle Database in > Ver. 7, which works fine. However, every time I shut the Window NT 4 Server > down the rollback segments go offline and have to be manual put back online. > I would like to configure this so the Rollback segments come on line > automatically could anyone please advise on how to complete this. > > Thanks > > Susan > > >