RBS not using

From: Onkar N Tiwary <onkarnath.tiwary_at_gmail.com>
Date: Fri, 3 Jun 2005 17:31:26 +0530
Message-ID: <a144e52105060305014996abcf@mail.gmail.com>

Hi all,
I have got one problem. I am running a script in which my first statement is " SET TRANSACTION USE ROLLBACK SEGMENT RBS01;" but the script is throwing error as " ora-01555: snapshot too old. Rollback segment rbs02 too small" . Now the problem is why its throwing error on RBS02 when I have set my transaction to use RBS01? Any comments on this or any suggestion ?

--

Thanks & Regards,
T. Onkar Nath
Ph : +91-9826728111(Cell)
to_onkar_at_yahoo.com
onkarnath.tiwary_at_gmail.com

--

http://www.freelists.org/webpage/oracle-l Received on Fri Jun 03 2005 - 08:06:26 CDT