Anurag Varma wrote:
> 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
>
There are no LOBS in the database at all.
Received on Wed Dec 20 2006 - 11:46:55 CST
