Re: ORA-1555 snapshot too old: why?

wagen123_at_yahoo.com wrote:
> By any chance are you using lobs and is that being exported? LOB update
> does not use undo instead uses PCTVERSION. I have had ORA-1555 snapshot
> too old errors during export and we had a process that was updating the
> LOBS.
This was true in 8i .. but I believe is no longer true in 9i (as per doco ..).
You can force LOB to use PCTVERSION, but by default its supposed to use undo_retention.
But you raise an interesting point here... If export is failing on a table containing LOBs,
then OP might want to look into this arguent further.

Anurag Received on Wed Dec 20 2006 - 11:06:31 CST