Snapshot too old
- From: "Dean Paul" <oracledbam@xxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Sun, 15 Oct 2006 21:02:48 -0400
Hi,
I've been noticing "ORA-01555 caused by SQL statement below (Query
Duration=33219 sec, SCN: 0x0000.5c80a509): "
i changed undo_retention 16000 and undo tablespace is having enough space.
Any suggestions are welcome.
The table which we are running is having 39 millions of records.
Thx
_________________________________________________________________
Add fun gadgets and colorful themes to express yourself on Windows Live
Spaces
http://clk.atdmt.com/MSN/go/msnnkwsp0070000001msn/direct/01/?href=http://www.get.live.com/spaces/features
--
//www.freelists.org/webpage/oracle-l
Other related posts: