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:
