Re: Oracle 10g export data pump (consistent=Y)

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 22 May 2005 16:58:40 -0700
Message-ID: <1116806320.893127.55060@g43g2000cwa.googlegroups.com>

premmehrotra_at_hotmail.com wrote:
> I am on Windows 2000 and using Oracle 10G (10.1.0.3). In earlier
> versions of Oracle, Oracle 9i, I always did export with consistent=Y.
> In Oracle 10G, expdp, I do not see a consistent parameter, instead
see
> FLASHBACK_TIME.
>
> I am assuming, if I do not specify FLASHBACK_TIME, Oracle will not do
a
> consistent export. Therefore I must specify
> FLASHBACK_TIME="to_timestamp(date_when_export_started, "MM/DD/YYYY
> HH24:MI:SS)" to accomplish consistency.
>
> Prem

Prem I think you should probably double check the utilities manual (export section) for 10g. Haven't played with it yet. Received on Sun May 22 2005 - 18:58:40 CDT