hpuxrac wrote:
> 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
>
I've already been there and searched for 1555. I didn't find anything
related to ora-1555 that matches this case. All the responses related to
manual rbs management, cases where undo_retention was insufficient, or
cases where the undo tablespace size was insufficient. My case does not
fit any of these.
Received on Mon Dec 18 2006 - 09:17:59 CST
