Do an impdp with a file on the local computer

impdpimportoracle

I was given a dump file which is currently on my local computer. I want to import this to our Oracle 11G DB which is hosted on a server. Do I need to move this file to the server to do the impdp or is there a way that I can do the impdp while referencing that the file is on my local PC?

Best Answer

Should be possible, provided the user that the DB service is running as can access the file share.

If the above is true, then you would have to create the directory object: 

create directory MYIMPORTDIR as '\\mycomp\mydir';

then run your impdp like:

impdp [username]/[pass] directory=MYIMPORTDIR dumpfile=expdat_1234.dat
Related Question