Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> datapump impdp parallel option
Hi,
I have a database running 10.1.0.4. I need to re-partition a large table on a different field. This table is partitioned daily with each partition holding 20+ million rows and average of 6.5 gig daily.
When using expdp I used the dumpfile wildcard (%U) with a parallel degree of 8. The export was very fast at about 2 to 3 minutes per partition. While importing I have been trying different degrees of parallel from 2 to 4 but I only see one of the worker processes doing anything. The import is taking about 40 minutes. I was expecting it to be much faster.
The data in the dumpfiles should span multiple partitions.
Any suggestions would be appreciated.
Thanks
Chris Merrill
901 371 8000 ext 17873
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Oct 10 2006 - 10:26:12 CDT
![]() |
![]() |