Re: Rollback segment

From: <rspeaker_at_my-dejanews.com>
Date: Tue, 19 Jan 1999 17:38:49 GMT
Message-ID: <782fv7$9jh$1@nnrp1.dejanews.com>

try adding a few more rollback segments -- it sounds like you have used segment 1, moved on to segment 2, then tried to return to segment 1 again, all within the same 80-120 M transaction.

HTH
Roy

In article <DQZo2.292$12.37818_at_news.tpnet.pl>, "Gerard Szyja" <gszyja_at_compass.pl> wrote:
> 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
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Jan 19 1999 - 11:38:49 CST

Re: Rollback segment - ORA-01581