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

  • From: Michael McMullen <ganstadba@xxxxxxxxxxx>
  • To: <brad_peek@xxxxxxxxx>
  • Date: Mon, 18 Jul 2011 14:53:24 -0400

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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
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


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


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


The DB version is v11.2.

Sent from my iPad 



Other related posts: