Skip to Main Content
  • Questions
  • Data Pump Export File to Remote Directory Location

Breadcrumb

May 4th

Question and Answer

Chris Saxon

Thanks for the question, Gopal.

Asked: May 19, 2016 - 12:49 pm UTC

Last updated: May 24, 2016 - 6:51 am UTC

Version: 11GR2

Viewed 10K+ times! This question is

You Asked

Hello Tom,
Thank you for your last replay, I have one another question regarding Data Pump.
My Question is:
We have one separate Data Storage machine for storing some important files. I have created one Directory like,
CREATE DIRECTORY MY_DUMP AS '\\192.168.1.25\Shared' and everyone has rights to access those Shared directory. Now I am executing expdp command like,
EXPDP uname/pass123@orcl SCHEMAS=TEST DIRECTORY=MY_DUMP DUMPFILE=DP_EXP.dmp LOGFILE=DP_EXP.log COMPRESSION=ALL;

command generating an error like,

ORA-39002: invalid operation
ORA-39070: Unable to open the log file. etc etc.

I have given all permission to everyone in shared folder. Is it possible to do like this ?
If i used EXP command and provide FILE=\\192.168.1.25\Shared\EXP.dmp option , it is working perfectly. is it possible to do same thing in EXPDP ?

Yes, I am using this is on Windows and all services are running perfectly.



Thank You Tom , after reading this thread https://community.oracle.com/thread/2310624 , my problem is solved.

and Chris said...

Have you checked that the local system account can see the share though?

"Oracle service runs under local system account by default and this local system account cannot see what you have mapped as the mappings are unique to each user account. You can check Start --> Run --> Services.msc --> OracleServiceXXXX ---> Properties --> Logon"

--

Are you running this on Windows?

If so, are you sure the Oracle service is running under an account that can see the drive?

Check this thread for more details:

https://community.oracle.com/thread/2310624

Is this answer out of date? If it is, please let us know via a Comment

More to Explore

Data Pump

All of the database utilities including Data Pump are explained in the Utilities guide.