Data Pump Export Parallel

The number of parallels is usually determined by the number of CPUs. For example, below are 2 parallel data pump exports.

-bash-3.2$ expdp "'/ as sysdba'" directory=dump_dir schemas=scott dumpfile=scott1.dmp,scott2.dmp logfile=scott.log reuse_dumpfiles=y parallel=2

1	-bash-3.2$ expdp "'/ as sysdba'" directory=dump_dir schemas=scott dumpfile=scott1.dmp,scott2.dmp logfile=scott.log reuse_dumpfiles=y parallel=2

We can also provide automatic dumpfile creation as much as the parallel number.

-bash-3.2$ expdp "'/ as sysdba'" directory=dump_dir schemas=scott dumpfile=scott%U.dmp logfile=scott.log reuse_dumpfiles=y parallel=2

1	-bash-3.2$ expdp "'/ as sysdba'" directory=dump_dir schemas=scott dumpfile=scott%U.dmp logfile=scott.log reuse_dumpfiles=y parallel=2

Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux