A step by step guide to using oracle’s impdp datapump over NETWORK LINK
by a novice non linux user
OK there are plenty of web results for how to use impdp but none of them singularly gave a good end to end description of the process.
Some background
My project have been piggybacking on another project’s DB for testing, and now want to move on to their own.
So we needed to copy all common data from the other project’s DB.
Having set up a shiny new oracle install (installing oracle 10.2 xe on suse) here’s what I had to do.
This post has moved to:
http://www.setupsteps.net/2008/07/step-by-step-guide-to-using-impdp-over.html
July 27, 2008 at 6:49 am
Hello,
I was hoping to use your data pump example to import data over a network. However, there’re several missing steps (makes the process unclear). Each step should clearly state on which machine (source or target) the action is being performed. It has been stated (through oracle documentation) that a dump directory is NOT required if doing an import via network link…it’s a direct data transfer (that would make the CREATE DIRECTORY step unnecessary right?)
Further, where are you performing these steps? At a system prompt? SQLPLUS prompt? What OS are you using?
Thanks much in advance.
Sam
October 22, 2009 at 11:48 pm
Sam,
Were you able to figure it out?
Peggy
July 27, 2008 at 10:39 am
Hi Sam,
Sorry it’s unclear about the OS, I had just written another post about installing the server on SuSe 10.3.
I will update the post shortly, but here’s the info you’re missing:
As far as i know the create directory is necessary (on your target system) as it needs somewhere to store the dump while it processes. All commands except the
impdp BLAH DIRECTORY=dmpdir NETWORK_LINK=blahsyslink;
are run on the target DB client, and the final one above is run on the command line (on the target machine, in the ORACLE bin directory.