Skip to Main Content

Database Software

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!

Expdp parallel parameter not splitting dumpfiles

Ghana IT Access BankApr 11 2017 — edited Apr 12 2017

Hello Team,

Datapump export is not splitting dumpfiles according to number of parallel parameter only one dumpfile is created even though we have specified parallel=10.

Below is the script i am using

expdp ghsadb/xxxx DIRECTORY=test2 parallel=10 CONTENT=DATA_ONLY tables=ACTB_HISTORY DUMPFILE=ACTB_HISTORY_%U.dmp   logfile=ACTBHISTORY.log compression=all CLUSTER=N

Environment details:

Platform       =           Solaris 11.3 SPARC 64bit

Database     =           11.2.0.2    (2 node rac )

I run the same script on another database (11.2.0.2 single node ) and it worked fine.

what could be the reason for this anomaly.

Please assist.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 10 2017
Added on Apr 11 2017
16 comments
4,589 views