 | | | Strange snapshot too old during a select statement | Strange snapshot too old during a select statement 2004-03-11 - By NGUYEN Philippe (Cetelem)
Hi list!
we encounter a very strange "ORA-01555 (See ORA-01555.ora-code.com) : snapshot too old :rollback segment
number 3 with name "_SYSSMU3$ " too small "
This is a very long query
With a query that only make a select statement.
We have open a TAR with Oracle Support but they say that it 's not possible
since this only a "select " statement ?!!
Any idea ?
TIA
Philippe
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN " >
<HTML >
<HEAD >
<META HTTP-EQUIV= "Content-Type " CONTENT= "text/html; charset=iso-8859-1 " >
<META NAME= "Generator " CONTENT= "MS Exchange Server version 5.5.2657.73 " >
<TITLE >Strange snapshot too old during a select statement </TITLE >
</HEAD >
<BODY >
<P > <FONT SIZE=2 >Hi list! </FONT >
<BR > <FONT SIZE=2 >we encounter a very strange "ORA-01555 (See ORA-01555.ora-code.com) : snapshot too old :rollback segment number 3 with name "_SYSSMU3$" too small" </FONT >
<BR > <FONT SIZE=2 >This is a very long query </FONT >
<BR > <FONT SIZE=2 >With a query that only make a select statement. </FONT >
<BR > <FONT SIZE=2 >We have open a TAR with Oracle Support but they say that it 's not possible since this only a "select" statement ?!! </FONT >
<BR > <FONT SIZE=2 >Any idea ? </FONT >
</P >
<P > <FONT SIZE=2 >TIA </FONT >
<BR > <FONT SIZE=2 >Philippe </FONT >
</P >
</BODY >
</HTML >
|
|
|