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.
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