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
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
Other related posts:
