Home » RDBMS Server » Server Utilities » Parallel EXPORT & IMPORT (oracle version 10g Windows XP)
Parallel EXPORT & IMPORT [message #542249] Mon, 06 February 2012 01:47 Go to next message
muktha_22
Messages: 408
Registered: December 2009
Senior Member
Hi All,

It might be a dump question, but I need a possibilities.

We have a huge size of a database, and every week we EXPORT the LIVE DB. And then we IMPORT into the TEST DB server.

But this method takes long time, and the developers has to suspend their work until the import get done (Because speed will get increased, otherwise import will take more time).

Q: Now the question is, is there any possible way of doing the EXPORT and IMPORT simultaneously?



Regards:
Muktha
Re: Parallel EXPORT & IMPORT [message #542254 is a reply to message #542249] Mon, 06 February 2012 02:04 Go to previous messageGo to next message
Michel Cadot
Messages: 59998
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, you can use impdp with network_link option, it export and import at the same time through a database link.

Regards
Michel
Re: Parallel EXPORT & IMPORT [message #542255 is a reply to message #542249] Mon, 06 February 2012 02:05 Go to previous messageGo to next message
Littlefoot
Messages: 19889
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Try with NETWORK_LINK IMPDP parameter.
Re: Parallel EXPORT & IMPORT [message #542728 is a reply to message #542255] Thu, 09 February 2012 23:39 Go to previous messageGo to next message
muktha_22
Messages: 408
Registered: December 2009
Senior Member
Hi Michel/Little.

Thanks a ton for a prompt reply.
It is very much useful.

Regards.
Muktha
Re: Parallel EXPORT & IMPORT [message #542826 is a reply to message #542728] Fri, 10 February 2012 05:15 Go to previous messageGo to next message
x-oracle
Messages: 347
Registered: April 2011
Location: gujarat
Senior Member
hey can you send me this syntax muktha
how can you did this
Re: Parallel EXPORT & IMPORT [message #542835 is a reply to message #542826] Fri, 10 February 2012 06:17 Go to previous messageGo to next message
Michel Cadot
Messages: 59998
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Are you unable to read the documentation?
You just have to click on the link!

Regards
Michel
Re: Parallel EXPORT & IMPORT [message #543183 is a reply to message #542835] Mon, 13 February 2012 05:36 Go to previous messageGo to next message
x-oracle
Messages: 347
Registered: April 2011
Location: gujarat
Senior Member
yes michel
and i did this also


E:\oracle\product\10.2.0\db_1\BIN>impdp zhena/***@prac tables=emp1 directory=practic
e network_link=pom remap_schema=scott:zhena


but michel if i want to export and import full database parallel so what can i do
Re: Parallel EXPORT & IMPORT [message #543185 is a reply to message #543183] Mon, 13 February 2012 05:42 Go to previous messageGo to next message
John Watson
Messages: 4861
Registered: January 2010
Location: Global Village
Senior Member
shaan, clik on that link and then hit Page Down a couple of times.
Re: Parallel EXPORT & IMPORT [message #543190 is a reply to message #543183] Mon, 13 February 2012 06:03 Go to previous message
Michel Cadot
Messages: 59998
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
shaan121 wrote on Mon, 13 February 2012 12:36
yes michel
and i did this also


E:\oracle\product\10.2.0\db_1\BIN>impdp zhena/***@prac tables=emp1 directory=practic
e network_link=pom remap_schema=scott:zhena


but michel if i want to export and import full database parallel so what can i do


What about using the PARALLEL option (and reading the documentation we pointed you to)?

Regards
Michel

[Updated on: Mon, 13 February 2012 06:03]

Report message to a moderator

Previous Topic: Export from Sql server and Import into Oracle 9i
Next Topic: impdp takes huge time in oracle11gR2 !
Goto Forum:
  


Current Time: Sat Dec 20 09:18:42 CST 2014

Total time taken to generate the page: 0.13476 seconds