I recall that the first time I saw ORA-1555 (See ORA-1555.ora-code.com) I did not understand how things worked. My complaint to Oracle was that I was not using snapshots. :)
The terminology in the error message is less than straightforward.
-- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist
On 6/3/05, Lex de Haan <lex.de.haan@(protected)> wrote: > > > you indeed don't understand how things work; you typically use *all* > rollback > segments to produce read consistency, depending on who changed the block. > the > only thing you achieve with SET TRANSACTION is that if you start making > changes > yourself, you will write undo information to the rollback segment of your > choice. > > kind regards, > > Lex. > > -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --- > Steve Adams Seminar http://www.naturaljoin.nl/events/seminars.html > -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --- > -- --Original Message-- -- > From: oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)] > On > Behalf Of Onkar N Tiwary > Sent: Friday, June 03, 2005 14:50 > To: Lex de Haan > Cc: oracle-l@(protected) > Subject: Re: RBS not using > > Lex/Dennis, > Thanx for the suggestion but my main query is why my transaction is not > using > RBS01 when I have set the same for the current transaction?? No doubt u > guys are > absolutely right but when I am setting the transaction to use > RBS01 then it should use that only and not the other rollback segment(if I > am > not wrong). >
