Mladen - We could use dbms_metadata if constraints, or a few other things like
roles, grants DDLs were needed. This is part of a migration process using XTTS,
and I used CONSTRAINT only as an example because it's the easiest to reproduce
the issue with.
Jack - We did try SCHEMAS=<> instead if FULL=Y, and it skipped the slow
INSERT..SELECT and went straight to getting the DDL using dbms_metadata (pls
check this thread, I'd posted that internal SQL). So, we 'could' use that
approach but then the challenge is very large number of schemas in our DB.
On Friday, October 21, 2016 9:48 AM, Mladen Gogala
<gogala.mladen@xxxxxxxxx> wrote:
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