Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ORA-1555 snapshot too old: why?

ORA-1555 snapshot too old: why?

From: Chuck <skilover_nospam_at_bluebottle.com>
Date: Fri, 15 Dec 2006 22:26:21 GMT
Message-ID: <hiFgh.107$Eo.88@trnddc08> 





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

Received on Fri Dec 15 2006 - 16:26:21 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US