Re: ORA-01562

From: Christoph Kukulies <kuku_at_accms33.physik.rwth-aachen.de>
Date: 19 Jun 2002 10:51:09 GMT
Message-ID: <aepnmt$gb8$1@nets3.rz.RWTH-Aachen.DE>

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?

--
Chris Christoph P. U. Kukulies kukulies_at_rwth-aachen.de

Received on Wed Jun 19 2002 - 05:51:09 CDT