Home » RDBMS Server » Server Utilities » 10.1.0.4 Windows - Datapump across machines
10.1.0.4 Windows - Datapump across machines [message #200884] Wed, 01 November 2006 15:01 Go to next message
bogey
Messages: 53
Registered: February 2006
Member
I'm using TOAD for administration and I'm trying to move/copy a schema from SERVER A to SERVER B.

I not only need the schema but all data contained within that schema. Using the datapump I need to export data using the data pump, manually copy the .dmp file to another server then use the data pump import. My question is: Is that the best way to do this?
Re: 10.1.0.4 Windows - Datapump across machines [message #200885 is a reply to message #200884] Wed, 01 November 2006 15:04 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> Using the datapump I need to export data using the data pump, manually copy the .dmp file to another server then use the data pump import
No need.
Just read the earlier post.
http://www.orafaq.com/forum/t/71724/42800/
Re: 10.1.0.4 Windows - Datapump across machines [message #200894 is a reply to message #200885] Wed, 01 November 2006 15:37 Go to previous messageGo to next message
bogey
Messages: 53
Registered: February 2006
Member
Guess that's what the search button is for, huh? I'll check out the article/post. Thanks for the quick reply

dan
Re: 10.1.0.4 Windows - Datapump across machines [message #200918 is a reply to message #200894] Wed, 01 November 2006 22:17 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

My question is: Is that the best way to do this?
Yes You can.


If above two method post by ur previous post is not successful.
like on network import operation is sometime slow or through "connect@string". connection problem then you go for cut n paste option.
Previous Topic: Import to remote server
Next Topic: expdp&impdp about object OID??
Goto Forum:
  


Current Time: Tue Jul 02 16:33:28 CDT 2024