Oracle Datapump export/import
database, oracle, oracle10g
Solution
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
Problem
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.