Oracle Datapump export/import

Question

I am trying to copy data b/w two databases and both sit on different servers. Both are Oracle 10g.

On my pc, i am connected to live database through Toad and there is 10g client installed on my pc.

Through Toad i am trying to export data dump file but on my pc i can't find expdp.exe file, i think this component is not installed on my pc.

How can i install expdp.exe on my pc?

Can i export data dump files on my pc(network) and not on server?

By default, dump files are copied on server, but can i copy and paste them on my pc and then use those file to import data on different server through Toad.

Answer 1

The files for the Oracle datapump export/import can only reside on the same server as the Oracle database. If Oracle client was installed on your PC, you should have expdp/impdp utilities. Just make sure you call them from command line, not from Toad.

So, to summarize. To transfer data from one Oracle server to another:

• run expdp from your PC
• copy the dump file from the server to your PC; it might be wise to also grab the generated log file while you are at it
• copy the dump file from your PC to another server
• run impdp from your PC