RE: Snapshot too old from READ-ONLY table (data pump export)

From: Michael McMullen <ganstadba_at_hotmail.com>
Date: Mon, 18 Jul 2011 14:53:24 -0400
Message-ID: <SNT130-ds2158CC0D14AB04E7E45B7CA64A0_at_phx.gbl>

Force a FTS on the table, have it get the error instead of you. This can be done either via stats gathering or a query.  

---

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Brad Peek
Sent: Monday, July 18, 2011 2:14 PM
To: David Roberts
Cc: Bobak, Mark; Oracle-L List
Subject: Re: Snapshot too old from READ-ONLY table (data pump export)  

Thanks to you and others I have had some informative posts that have helped me understand why this may be happening. One suggested work around was to try and speed up the export (e.g. try parallel) which might work as long as the export completes before the min SCN has been overwritten in the UNDO segments.  

I do intend to try that. Does anyone have a different suggestion as a work around?  

Having another work around would be helpful because I can envision cases where the size of the segment being exported and the high level of update activity in the system could make that approach very much a hit-or-miss proposition.  

The DB version is v11.2.

Sent from my iPad    

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Jul 18 2011 - 13:53:24 CDT