Rollback segment question

From: Tony Adolph <tony.adolph_at_viaginterkom.de>
Date: Fri, 08 Oct 1999 14:52:47 GMT
Message-ID: <7tl0fo$mar$1@nnrp1.deja.com>

Hello All,

I am getting

1999.09.08.12.26.34.717 SMON: following errors trapped and ignored: ORA-00604: error occurred at recursive SQL level 1 ORA-01555: snapshot too old: rollback segment number 33 with name "BIG_RBS01" too small

I have 33 rollback segments with an initial and next extent of 102400 and BIG_RBS01 which has an initial of 150M and next of 1M.

It was my intention for only the reports scripts to use BIG_RBS01 via the alter session use rollback.....etc. All of the rollback segs are private and there seems to be freespace enough for all of the segments to grow.

What have I missed out?

Thanks in advance
Tony Adolph

PS Ora 7.3.4 on NT4

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Oct 08 1999 - 09:52:47 CDT