Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
In today’s article, we will be learning to use Parallel during Export in data pump.
1 2 3 4 5 | expdp "'/ as sysdba'" directory=expimp_dump tables=webtelreporting_qsdp.ejb__timer__tbl,webtelreporting_qsdp.aveaedr19agu,webtelreporting_qsdp.aveaedr14agu,webtelreporting_qsdp.counter_cache_qsdp,webtelreporti ng_qsdp.session_data_record_qsdp,webtelreporting_qsdp.counter_qsdp,webtelreporting_qsdp.counter_type_qsdp,webtelreporting_qsdp.record_type_desc_qsdp,webtelreporting _qsdp.event_data_record_qsdp,webtelreporting_qsdp.counter_history_qsdp dumpfile=rep_mwrep08%u.dmp logfile=rep_mwrep08.log parallel=16 cluster=n flashback_scn= 12482481618338 exclude=trigger,grants,policy,rls_policy,ref_constraint,synonym,job,sequence,constraint |
Here;
%u: Let the names of the Dump Files it will create start with rep_mwrep08 and then create it sequentially.
Example:
