• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 372
  • Last Modified:

data pump

How to import a schema with the .dmp file on a different server?
0
msimons4
Asked:
msimons4
  • 3
  • 2
5 Solutions
 
slightwv (䄆 Netminder) Commented:
With the corresponding imp (impdp) command.

If the file was created with exp, then use imp.

You can run the utility remotely if the server is on the same network.

Otherwise, ftp or otherwise binary copy the file to the other server and run the imp or impdp command from there.

If you can provide more information like the parameters used to export the file, how you want to handle the schema, into the same name or different one, etc...  we'll be able to better answer he question.
0
 
slightwv (䄆 Netminder) Commented:
Duh, the subject of the question is 'data pump'.  

I always like to do this local so ftp/copy the file to the new server.

In the database create a DIRECTORY for datapump (or put the file in the default location),  then just run impdp.
0
 
mrjoltcolaCommented:
Examples:

impdp system/admin DIRECTORY=expdp_dir DUMPFILE=expfull.dmp SCHEMAS=scott

impdp scott/tiger DIRECTORY=expdp_dir DUMPFILE=expscott.dmp FULL=y




0
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

 
msimons4Author Commented:
I expdp from production. Then I ftp the file to the test server. I have another test server that doesn't have enough space so I want to impdp from one test server to the other.
0
 
slightwv (䄆 Netminder) Commented:
I don't think you can run impdp remotely.  The new datapump commands need an Oracle DIRECTORY.

Can you share the folder and mount the folder from the remote server?

If not, can you use the old exp/imp commands to take a new export?  These can run remotely.
0
 
mrjoltcolaCommented:
You can, however, use impdp and run directly against a network link. You need to create a remote database link from your TEST server back to your PROD server, then run impdp on the TEST server with network_link=PROD and it will get data directly from PROD rather than using an intermediate file. This assumes you have a direct network route between the two.

This is one "weaknes / strength" of data pump vs old export/import. I prefer to use the old one due to simplicity, but in some cases the performance is now adequate for a remote export and data pump must be used, or you must forego the remote option and just move the files physically.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now