How to export schema with Parallel method by using expdp
Posted by Mir Sayeed Hassan on October 13th, 2018
How to export schema with Parallel method by using expdp
[oracle@testdb dump_bkp]$ expdp system directory=dump_bkp dumpfile=expdp%U-`date '+%d%m%Y_%H%M%S'`.dmp logfile=expdp-`date '+%d%m%Y_%H%M%S'`.log schemas=mir PARALLEL=2 Export: Release 11.2.0.4.0 - Production on Sat Oct 13 15:25:00 2018 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. Password: Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options FLASHBACK automatically enabled to preserve database integrity. Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01": system/******** directory=dump_bkp dumpfile=expdp%U-13102018_152500.dmp logfile=expdp-13102018_152500.log schemas=mir PARALLEL=2 Estimate in progress using BLOCKS method... Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA Total estimation using BLOCKS method: 192 KB . . exported "MIR"."T1" 5.093 KB 7 rows . . exported "MIR"."T2" 5.085 KB 6 rows . . exported "MIR"."T3" 5.078 KB 5 rows Processing object type SCHEMA_EXPORT/USER Processing object type SCHEMA_EXPORT/SYSTEM_GRANT Processing object type SCHEMA_EXPORT/ROLE_GRANT Processing object type SCHEMA_EXPORT/DEFAULT_ROLE Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA Processing object type SCHEMA_EXPORT/TABLE/TABLE Processing object type SCHEMA_EXPORT/TABLE/AUDIT_OBJ Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS Master table "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded ****************************************************************************** Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is: /backup/dump_bkp/expdp01-13102018_152500.dmp /backup/dump_bkp/expdp02-13102018_152500.dmp Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully completed at Sat Oct 13 15:25:06 2018 elapsed 0 00:00:03
[oracle@testdb dump_bkp]$ pwd /backup/dump_bkp
[oracle@testdb dump_bkp]$ ls expdp01-13102018_152500.dmp expdp02-13102018_152500.dmp expdp-13102018_152500.log
Note:
As you can see there are multiple files are created like – expdp01 & expdp02 & time consumption will be faster by using parallel option compare to normal
================Hence tested & verified in our test env================