Strange snapshot too old during a select statement
- From: "NGUYEN Philippe (Cetelem)" <philippe.nguyen@xxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 11 Mar 2004 09:46:17 +0100
Hi list!
we encounter a very strange "ORA-01555 : 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
Other related posts:
