Expdp – Impdp ( Export – Import ) Parallel in Oracle

I will explain Expdp – Impdp ( Export – Import ) Parallel in Oracle in this post.

 

Expdp Parallel in Oracle

You can improve export and import performance by using Paralell option. PARALLEL parameter can be used only with Enterprise Edition of Oracle Database.

 

 

 

 

Parallelism count depends on the number of CPU. For this, data pump technology allows us to improve datapump performance with parallel parameters. Parallelism can be given as follows. This number of parallelism should not be used more than the number of CPU of the physical server.

 

You should use the %U wildcard to create multiple dumpfiles.

 

Dump files personel01.dmp,personel02.dmp,personel03.dmp….personel08.dmp and so on will be created in a round-robin fashion in the directories pointed to by the DATAPUMP directory. For best performance, these should be on separate I/O channels

 

You can use the PARALLEL parameter in the expdp and impdp as follows.

expdp \"/ as sysdba\" tables=HR.personel DIRECTORY=DATAPUMP DUMPFILE=personel%U.dmp LOGFILE=personel.log PARALLEL=8

Processing object type TABLE_/export/TABLE/TABLE
Processing object type TABLE_/export/TABLE/TABLE_DATA
. . /exported "HR"."personel":"P_202107" 0 KB 0 rows
. . /exported "HR"."personel":"P_202106" 1228. GB 25127368689 rows
Master table "SYS"."SYS_/export_TABLE_04" successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.SYS_/export_TABLE_04 is:
/export/personel01.dmp
/export/personel02.dmp
/export/personel03.dmp
/export/personel04.dmp
/export/personel05.dmp
/export/personel06.dmp
/export/personel07.dmp
/export/personel08.dmp
Job "SYS"."SYS_/export_TABLE_04" successfully completed at Wed Aug 4 12:51:27 2021 elapsed 0 00:48:57




 

Impdp Parallel in Oracle

You can use PARALEL parameter in the impdp as follows.

impdp \"/ as sysdba\" tables=HR.personel DIRECTORY=DATAPUMP DUMPFILE=personel%U.dmp LOGFILE=personel.log PARALLEL=8

 

 

 

You should read the following post to learn more details about Oracle Datapump.

Oracle Data Pump – Export Import ( Expdp Impdp ) Tutorial with Examples-4

 

 

 

Do you want to learn Oracle Database for Beginners, then read the following articles.

Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )

 2,025 views last month,  1 views today

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

Leave a Reply