Home » RDBMS Server » Server Utilities » Impdp parallel worker status
Impdp parallel worker status [message #197262] Tue, 10 October 2006 15:39
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.

Previous Topic: Export Script
Next Topic: Need clarification.
Goto Forum:

Current Time: Fri Oct 21 18:58:08 CDT 2016

Total time taken to generate the page: 0.12847 seconds