Oracle-L: Re: strange issue with setting transaction

From: Ron Thomas <rthomas_at_hypercom.com>
Date: Sat, 04 Jan 2003 14:33:42 -0800
Message-ID: <F001.0052729B.20030104143342@fatcity.com>

Any commits in the script that you run?

Ron Thomas
Hypercom, Inc
rthomas_at_hypercom.com
Each new user of a new system uncovers a new class of bugs. -- Kernighan

                                                                                                                                     
                      sergei_at_netflip.co                                                                                              
                      m                        To:       ORACLE-L_at_fatcity.com                                                        
                      Sent by:                 cc:                                                                                   
                      root_at_fatcity.com         Subject:  strange issue with setting transaction                                      
                                                                                                                                     
                                                                                                                                     
                      01/03/2003 12:49                                                                                               
                      PM                                                                                                             
                      Please respond to                                                                                              
                      ORACLE-L

I am running 8.1.6 on solaris 2.8.

Before running a large update, I tried to set a specific rollback segment by:
Set transaction use rollback segment RBIG20;

The transaction runs for a while and fails with:

ORA-01555: snapshot too old: rollback segment number 29 with name "R27" too
Small

Any idea?

Thank you

Sergei

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Sergei
  INET: sergei_at_netflip.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).





-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ron Thomas
  INET: rthomas_at_hypercom.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

Received on Sat Jan 04 2003 - 16:33:42 CST