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: Converting Non-Partitioned table to Partition table
Next Topic: Fine Tuning This query
Goto Forum:

Current Time: Sat Aug 19 13:56:32 CDT 2017

Total time taken to generate the page: 0.07547 seconds