RE: Export datapump is INCONSISTENT

  • From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
  • To: "yong321@xxxxxxxxx" <yong321@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>, "jcmiranda@xxxxxxxxx" <jcmiranda@xxxxxxxxx>
  • Date: Thu, 10 Feb 2011 12:12:37 -0700

Thanks Yong and Juan for the helpful info.  I had also been under the 
misconception that data pump was consistent by default.  I just wanted to add 
that MOS Doc ID 377218.1 also provides some detail on this topic.  The Oracle 
documentation and expdp output is very misleading on this so I wouldn't be 
surprised if there are many more people out there that are also confused and 
unaware that their data pump exports are inconsistent.  I think Oracle should 
either bring back the consistent=y parameter for data pump, or add an option 
for flashback_time=now or flashback_scn=current or something like that instead 
of this ridiculously long string that you have to use instead to get the same 

hh24:mi:ss'),'yyyy-mm-dd hh24:mi:ss')"

Maybe I'll file an enhancement request for it.


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Yong Huang

I did some research on data pump export flashback_time and flashback_scn at

Privileged/Confidential Information may be contained in this message or 
attachments hereto. Please advise immediately if you or your employer do not 
consent to Internet email for messages of this kind. Opinions, conclusions and 
other information in this message that do not relate to the official business 
of this company shall be understood as neither given nor endorsed by it.

Other related posts: