| Parallel EXPORT & IMPORT [message #542249] |
Mon, 06 February 2012 01:47  |
muktha_22
Messages: 527
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 #543190 is a reply to message #543183] |
Mon, 13 February 2012 06:03  |
 |
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
shaan121 wrote on Mon, 13 February 2012 12:36yes 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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
