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

use

ALTER ROLLBACK SEGMENT "R01" ONLINE; and then to use it you must either take all the other rollback segments off line or issue

SET TRANSACTION USE ROLLBACK SEGMENT R01; from the session that needs to use it.

Where R01 is a rollback segment big enough to do what you require.

Simon Webb wrote:

> I've created a segment but cannot use it as it is offline. I need a larger
> segment because I've created a database containing tables with tens of
> thousands of records, and cannot perform many operations unless I process
> records one at a time.
>
> Thanks in advance
Received on Wed Mar 31 1999 - 03:50:39 CST