Re: About Rollback Segments

Looks like you have gone out of extents in your Rollback segment. Create a big enough rollback segment and set the transaction to it by
"SET TRANSACTION USE ROLLBACK SEGMENT <BIG_ROLLBACK_NAME>" No need for disable.In fact you have to enable your big rollback by the above command.
Hope this helps

Jorge A. San Martín <jsanmart_at_tortuga.its.cl> wrote in article <347F484D.8CD2DD84_at_tortuga.its.cl>...
> Hi,
> I have a lot of doubts about rollback segments (RS), I work with
> Oracle Server 7.3.2.3, we have a table with a lot of records; 1,000,000
> daily aprox, which must be deleted, but the rollback segments excedes
> the MAXEXTENTS parameter. I have read the manual about RS, but I don't
> know what values are the bests for a RS for this task. Is there a way
> to disable the RS ?
>
> Thanks,
> Saludos
> Jorge San Martín.
> jsanmart_at_its.cl
> ITS S.A.
>
>
Received on Tue Dec 09 1997 - 00:00:00 CET