Re: Very slow metadata-only expdp
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Fri, 21 Oct 2016 10:48:06 -0400
Message-ID: <14ff50f2-ec5d-a6d1-ba5a-a41f86b8cbc5_at_gmail.com>
Date: Fri, 21 Oct 2016 10:48:06 -0400
Message-ID: <14ff50f2-ec5d-a6d1-ba5a-a41f86b8cbc5_at_gmail.com>
On 10/21/2016 03:29 AM, Oracle List wrote:
> Hi Mladen,
>
> There must be a confusion. The expdp is not for copying the whole DB,
> but only the metadata and that too, just for Constraints.
>
> Deepak
>
May I inquire as to what should be the purpose of this extraction? If you need DDL statements for tables, you can use DBMS_METADATA.GET_DDL and do it in parallel, running 1 thread for each schema.
-- Mladen Gogala Oracle DBA Tel: (347) 321-1217 -- http://www.freelists.org/webpage/oracle-lReceived on Fri Oct 21 2016 - 16:48:06 CEST