Database 11g

Tuesday, April 3, 2018

How to Exclude Constraints in oracle using Datapump Expdp Utility



D:\app\MOIN\product\11.2.0\dbhome_1\BIN>expdp dumpfile=PRSEMP_EXCONST directory=full_imp tables=fmis.prs_master_employee_main EXCLUDE=CONSTRAINT

Export: Release 11.2.0.3.0 - Production on Tue Nov 22 23:25:22 2016

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Username: system
Password:

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYSTEM"."SYS_EXPORT_TABLE_01":  system/******** dumpfile=PRSEMP_EXCONST directory=full_imp tables=fmis.prs_master_employee_main EXCLUDE=CONSTRAINT
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 448 KB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/TRIGGER
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . exported "FMIS"."PRS_MASTER_EMPLOYEE_MAIN"           333.6 KB    1508 rows
Master table "SYSTEM"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded


Happy Learning....

No comments:

Post a Comment