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.........
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