Re: ORA-01562

From: Knut Talman <knut.talman_at_mytoys.de>
Date: Wed, 19 Jun 2002 13:45:51 +0200
Message-ID: <3D106EEF.B1B4AAEE@mytoys.de>

Christoph Kukulies wrote:
>
> Telemachus <telemachus_at_ulysseswillreturn.net> wrote:
> > Was there another error message ?
>
> I asked my colleague:
> He told me:
>
> ORA-01562: Fehler beim Erweitern der Rollback-Segmentnummer 2.
> ORA-01628: Max. Anzahl von Extents (121) für Rollback-Segment RB0 erreicht
>
> RBS1ORCL.ORA is 12 MB.
>
> I had set max_rollback_segments in INITORLC.ORA to (astronomical 1000)
> out of sheer desparation.
>
> Isn't there a way to set something to 'unlimited' to overcome this problem?

Of course there is:

ALTER ROLLBACK SEGMENT RBS1ORCL.ORA STORAGE (MAXEXTENTS UNLIMITED); BTW, http://technet.oracle.com is a good resource for looking up topics like this one.

Regards,

Knut Received on Wed Jun 19 2002 - 06:45:51 CDT