Tuesday 10 May 2016

IMPORT ONLY CONSTRAINTS IN ORACLE 10g,11g AND 12C USING IMPDP

IMPORT ONLY CONSTRAINTS IN ORACLE 10G,11G AND 12C


oracle@acserver01$ impdp system@server schemas=HR directory=pump1 dumpfile=contraint_only.dmp logfile=constraint_only.log include=ref_constraint

Import: Release 10.2.0.4.0 - 64bit Production on Wednesday, 11 May, 2016 6:06:57

Copyright (c) 2003, 2007, Oracle.  All rights reserved.
Password:

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Master table "SYSTEM"."SYS_IMPORT_SCHEMA_09" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_SCHEMA_09":  system/******** schemas=HR directory=pump1 dumpfile=constraint_only.dmp logfile=constraint_only.log include=ref_constraint


Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT.........

No comments:

Post a Comment