Re: stange rollback behavior

Misconception: "Snapshot too old" can be avoided by using "set transaction use rollback segment."

http://www.speakeasy.org/~jwilton/oracle/snapshot-too-old.html

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

On Thu, 8 May 2003, Hatzistavrou John wrote:



> In the past I had problem taking a consistent export from a very

> active database. At that time I had ORA-1555 error.  I though if I

> created a big rollback and force the export use it I would resolve

> the problem.  Thus I created an after logon schema trigger on the

> user I was specifying on the export command .  I have tested it and

> for a number of days thinks were going as expected.  Yesterday the

> export failed with ORA-1555 again but on different rollback than the

> one I have set in the after logon trigger.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jeremiah Wilton
  INET: jwilton_at_speakeasy.net

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).