Performing Parallel Data Pump Export in Oracle Database

      

Parallel exports enhance performance by utilizing multiple worker processes, significantly reducing the time required to export large datasets. #Execute below command to use parallel keyword and dumpfile name with %U. C:\Windows\System32>expdp directory=DIR_TEST schemas=test dumpfile=schema_%U.dmp logfile=schema.log parallel=2 Export: Release 19.0.0.0.0 - Production on Sat Mar 9 21:13:43 2024 Version 19.16.0.0.0 Copyright (c) 1982, 2022, Oracle and/or its affiliates.  All rights reserved. Username: test Password: Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Starting "TEST"."SYS_EXPORT_SCHEMA_01":  test/******** directory=DIR_TEST schemas=test dumpfile=schema_%U.dmp logfile=schema.log parallel=2 Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA 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/TABLESPACE_QUOTA Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA Processing object type SCHEMA_EXPORT/STATISTICS/MARKER Processing object type SCHEMA_EXPORT/TABLE/COMMENT Processing object type SCHEMA_EXPORT/TABLE/TABLE Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX . . exported "TEST"."DEPT"                               6.531 KB       5 rows . . exported "TEST"."EMP"                                6.531 KB       5 rows Master table "TEST"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded ****************************************************************************** Dump file set for TEST.SYS_EXPORT_SCHEMA_01 is:   C:\BACKUP\SCHEMA_01.DMP   C:\BACKUP\SCHEMA_02.DMP Job "TEST"."SYS_EXPORT_SCHEMA_01" successfully completed at Sat Mar 9 21:14:28 2024 elapsed 0 00:00:41