Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Newbie Question how do I set rollback segment status = 'online' in PO7 for Win95

Re: Newbie Question how do I set rollback segment status = 'online' in PO7 for Win95

From: Frank van Bortel <f.van.bortel_at_vnl.nl>
Date: Tue, 06 Apr 1999 15:49:22 +0200
Message-ID: <370A10E2.8E146F45@vnl.nl>

Mike Burden wrote:

> use
>
> ALTER ROLLBACK SEGMENT "R01" ONLINE;
>
> <snip>

And add it to the initORCL.ora file, if you want it to be online after you start the
instance, e.g.:
rollback_segments=(rollback1, rollback2, rollback3)

--
Frank van Bortel

Technical Consultant Oracle
V&L Informatica BV


Work                                Home
Postbus 545                         Hunzestraat 4
7500 AM Enschede                    7555 WB Hengelo
(31)53.434.1500                     (31)74.242.5046


Received on Tue Apr 06 1999 - 08:49:22 CDT

Original text of this message

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