Home » RDBMS Server » Performance Tuning » datapump parallel
datapump parallel [message #197213] Tue, 10 October 2006 09:14 Go to next message
Messages: 2
Registered: October 2006
Location: Memphis
Junior Member
Hi all,

I have a large partitioned table that I exported using expdp. for the export I used the %U wildcard to export the partitions. Each partition is about 6.5 Gig. The export was very fast, about 2 minutes each.

I had to drop the table and rebuild it on a new partition key. While using the impdp along with parallel I am seeing only one worker doing all of the work. I have tried several different levels of the parallel option.

The data in the dumpfiles should span multiple partitions. A majority of it would be in 4 partitions .

This was in

Any help/suggestions would be apprecited.


[Updated on: Tue, 10 October 2006 12:30]

Report message to a moderator

Re: datapump parallel [message #198498 is a reply to message #197213] Tue, 17 October 2006 07:10 Go to previous message
Messages: 201
Registered: August 2006
Location: Denmark
Senior Member
Have You checked that You actually have the parallel option?

Standard Edition does not have this.

Previous Topic: Fine Tuning This query
Next Topic: Spool from DB table to flat file slow
Goto Forum:

Current Time: Tue Oct 25 00:05:29 CDT 2016

Total time taken to generate the page: 0.12529 seconds