Filed under things that make you go hmmm.... ok, I stand corrected, but submit that the spirit of the parameter might remain, whereas the actual original intention has left... there was no flashback back in the day... so really this is a new option/type of export now available that goes 'back in time' -- assuming you have flashback enabled. Joel Patterson Database Administrator 904 727-2546 -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Radoulov, Dimitre Sent: Tuesday, October 11, 2011 9:39 AM To: oracle-l@xxxxxxxxxxxxx Subject: Re: expdp without password On 11/10/2011 13:50, Joel.Patterson@... wrote: [...] IMP_FULL_DATABASE is for importing, (verses EXP_FULL_DATABASE). If you have a consistent export, you will have a consistent import. (note in older version of 'exp' there was a 'consistent' parameter... :) which is no longer part of 'expdp'). It is available in the latest release in legacy mode :) CONSISTENT Data Pump Export determines the current time and uses|FLASHBACK_TIME|. bit.ly/qPGPfc Regards Dimitre -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l