Chuck wrote:
> Oracle 9.2.0.7
>
> I got an ORA-1555 snapshot too old today on a export where consistent=y
> was set. The export failed at 6 hrs even though undo_retention was set
> to 8 hours. Querying v$undostat shows that during the time when the
> export was running a total of only 150m of undo was written. The undo
> tablespace is 4g. Why would I get an ora-1555 when undo_retention is set
> plenty high enough, and the undoblks written weren't anywhere near
> maxing out the undo tablespace?
>
> TIA
Tom Kyte has this all covered. Try looking for 1555 in
http://asktom.oracle.com
Received on Fri Dec 15 2006 - 17:10:21 CST
