| Can data pump utility can do imp while exp? [message #598349] |
Mon, 14 October 2013 03:42  |
snowball
Messages: 229
Registered: April 2006
Location: China
|
Senior Member |
|
|
Hi, Gurus
I met some problems with data pump tools.
We have a large db(oracle 10.2.0.5, single instance on hpux v11.11, data about 8TB), while we wanna migrate to Linux ia 64bit, 10.2.0.5 RAC.
The migrate window is around 20 hours, so the winodw can NOT be assign more hours.
As we consider if impdp & expdp work can start together, that will be save a lot of time.
So I wonder if there are any ways to implement this or any other ways can speed up and make the data integrate better?
Thanks very much.
[Updated on: Mon, 14 October 2013 03:43] Report message to a moderator |
|
|
|
| Re: Can data pump utility can do imp while exp? [message #598351 is a reply to message #598349] |
Mon, 14 October 2013 03:59  |
John Watson
Messages: 8964
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
|
The export and import run concurrently if you use Data Pump in network mode. However, I have sometimes found this to be too slow. You cannot parallelize the operation, and you never get direct path, only external table path (I believe this to be the case, but I am certainly open to correction). You can of course launch multiple Data Pump jobs, each using network mode.
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
