Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Newbie Question how do I set rollback segment status = 'online' in PO7 for Win95
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.5046Received on Tue Apr 06 1999 - 08:49:22 CDT