Home » RDBMS Server » Server Utilities » Can data pump utility can do imp while exp? (Oracle 10.2.0.5 64bit, HPUX PA 11.11 64bit)
Can data pump utility can do imp while exp? [message #598349] Mon, 14 October 2013 03:42 Go to next message
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 Go to previous messageGo to next message
John Watson
Messages: 4515
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.
Re: Can data pump utility can do imp while exp? [message #598442 is a reply to message #598351] Mon, 14 October 2013 21:45 Go to previous messageGo to next message
snowball
Messages: 229
Registered: April 2006
Location: China
Senior Member

Hi, John
Thanks very much. I will test it.
Any other way to speed up the expdp & impdp? I reviewed <Checklist for Slow Performance of Export Data Pump (expdp) and Import DataPump (impdp) [ID 453895.1]>, but it seems not very helpful .
Re: Can data pump utility can do imp while exp? [message #598448 is a reply to message #598442] Tue, 15 October 2013 01:36 Go to previous messageGo to next message
John Watson
Messages: 4515
Registered: January 2010
Location: Global Village
Senior Member
THere are techniques that may help, but you'd better see if it takes a day or week first.
Re: Can data pump utility can do imp while exp? [message #598927 is a reply to message #598448] Sun, 20 October 2013 00:16 Go to previous message
snowball
Messages: 229
Registered: April 2006
Location: China
Senior Member

John, Do you mean third party tools?
Previous Topic: EXPDP with query error
Next Topic: exp failed in 11.2.0.3
Goto Forum:
  


Current Time: Sat Aug 30 02:03:59 CDT 2014

Total time taken to generate the page: 0.14295 seconds