Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Datapump parallel & compress

user640001Aug 22 2012 — edited Aug 23 2012

Hi,

Oracle11gR2

Want to make the expdp process faster.

Can we use "parallel" and "compress" parameter at the same time for export datapump as mentioned below ?

job_name=exp_test
content=ALL
parallel=6
dumpfile=EXPDP:EXP_TEST_%U.dmp
logfile=EXPDP:EXP_TEST.log
schemas=SAMPLE
compression=all

As we are using %U so it will make 6 separate dump files, but how the compress will take place...will it individually compress those 6 separate dump files ?

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 20 2012

Added on Aug 22 2012

#general-database-discussions

8 comments

2,671 views