Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Rollback segment - ORA-01581

Rollback segment - ORA-01581

From: Gerard Szyja <gszyja_at_compass.pl>
Date: Tue, 19 Jan 1999 11:16:51 GMT
Message-ID: <DQZo2.292$12.37818@news.tpnet.pl>


We are running Oracle 8.0.4 on Windows NT. Tablespace for rollback segment - 300 M and AUTOEXTEND ON (3 GB free space on HDD)

2 identical rollback segments (online) :

   initial 5 M
   next 5 M
   optimal 25 M
   min 5
   max 2147483645

For large transaction rollback segment
extend to 80M - 120M and generate ORA-01581 error.

What is the reason for this error ?

Thanks in advance
Gerard Received on Tue Jan 19 1999 - 05:16:51 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US