Re: Rollback segment

From: Mark Wagoner <mwagoner_at_iac.net>
Date: Fri, 23 Feb 2001 10:04:25 -0500
Message-ID: <975u5q$mgl$1@genma.iac.net>

Or, if you are on an older version of Oracle that doesn't support the 'unlimited' clause, you can make each segment larger so it requires fewer of them.

"Sebastian Rehm" <Sebastian.Rehm_at_de.bosch.com> wrote in message news:3A967065.8456AFB8_at_de.bosch.com...
> ALTER ROLLBACK SEGMENT "RB0" STORAGE ( MAXEXTENTS UNLIMITED);
>
> Sebastian
>
> Renato De Ficis schrieb:
> >
> > Hi,
> > this is my error msg (translated from Italian):
> >
> > ORA-01562: extension of rollback segment number failed 2
> > ORA-01628: max number of additional areas (121) for rollback segment RB0
> >
> > How can I resolve this problem??
> > Thanks.
> >
> > --
> > Posted from alpha.show.it [194.184.40.2]
> > via Mailgate.ORG Server - http://www.Mailgate.ORG
Received on Fri Feb 23 2001 - 09:04:25 CST