DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Monday, August 31, 2015

Data Pump Parameter-Sample


Data Pump Parameters-Sample


export subsets of data by specifying the percentage

expdp system/oracle tables=scott.emp dumpfile=oe.dmp sample="scott"."emp":50 directory=test_dir

[oracle@oracle11g ~]$ expdp system/oracle tables=scott.emp dumpfile=oe.dmp sample="scott"."emp":50 directory=test_dir

Export: Release 11.2.0.3.0 - Production on Mon Aug 31 12:27:03 2015

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYSTEM"."SYS_EXPORT_TABLE_01":  system/******** tables=scott.emp dumpfile=oe.dmp sample=scott.emp:50 directory=test_dir
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 32 KB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
. . exported "SCOTT"."EMP"                               8.367 KB       9 rows
Master table "SYSTEM"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_TABLE_01 is:
  /u01/dump/oe.dmp
Job "SYSTEM"."SYS_EXPORT_TABLE_01" successfully completed at 12:27:18


expdp system/oracle tables=scott.emp dumpfile=scott.dmp sample="scott"."emp":50 directory=test_dir



[oracle@oracle11g ~]$ expdp system/oracle tables=scott.emp dumpfile=scott.dmp sample="scott"."emp":50 directory=test_dir

Export: Release 11.2.0.3.0 - Production on Mon Aug 31 12:29:16 2015

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYSTEM"."SYS_EXPORT_TABLE_01":  system/******** tables=scott.emp dumpfile=scott.dmp sample=scott.emp:50 directory=test_dir
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 32 KB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
. . exported "SCOTT"."EMP"                               8.289 KB       7 rows
Master table "SYSTEM"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_TABLE_01 is:
  /u01/dump/scott.dmp
Job "SYSTEM"."SYS_EXPORT_TABLE_01" successfully completed at 12:29:27



expdp system/oracle tables=scott.emp dumpfile=scott1.dmp sample="scott"."emp":20 directory=test_dir



[oracle@oracle11g ~]$ expdp system/oracle tables=scott.emp dumpfile=scott1.dmp sample="scott"."emp":20 directory=test_dir

Export: Release 11.2.0.3.0 - Production on Mon Aug 31 12:29:42 2015

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYSTEM"."SYS_EXPORT_TABLE_01":  system/******** tables=scott.emp dumpfile=scott1.dmp sample=scott.emp:20 directory=test_dir
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 12.79 KB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
. . exported "SCOTT"."EMP"                               8.046 KB       1 rows
Master table "SYSTEM"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_TABLE_01 is:
  /u01/dump/scott1.dmp
Job "SYSTEM"."SYS_EXPORT_TABLE_01" successfully completed at 12:29:52

No comments: