Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Paresh.

Asked: October 03, 2019 - 6:41 am UTC

Last updated: October 04, 2019 - 8:49 am UTC

Version: Oracle 12c (12.2.0.1.0)

Viewed 1000+ times

You Asked

Hi,

I am trying to take a dump of my database instance using expdp data pump utility to a mapped drive which is pointing to remote drive. I have the access to that drive.

Both Oracle is started with a user and remote desktop is also logged in with the same user.

I did following and getting error -

sql> create or replace directory DATA_PUMP_DIR as 'O:\expdpgmnew\';


O: is a mapped drive pointing to remote drive.
 
sql>GRANT READ, WRITE ON DIRECTORY DATA_PUMP_DIR TO <user_name>;

expdp -v <user_name>/<password>@<instance_name> dumpfile=dumpFile.dmp logfile=logFile.log tables=<schema.tablename>

Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation
ORA-29283: invalid file operation 
expdp -v <user_name>/<password>@<instance_name> dumpfile=dumpFile.dmp logfile=logFile.log tables=<schema.tablename>


Any help is appreciated.

Thanks!

and Connor said...

Take a look here

https://asktom.oracle.com/pls/asktom/asktom.search?tag=oracle-user-unable-to-access-network-locations-or-permission-issues


Rating

  (3 ratings)

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

Comments

Don't see the DIRECTORY parameter in the command line

A reader, October 04, 2019 - 5:45 am UTC 

Don't see the DIRECTORY parameter in the command line. 
Doesn't that need to be specified?

Chris Saxon
October 04, 2019 - 8:49 am UTC

It defaults to DATA_PUMP_DIR.

Paresh K, October 04, 2019 - 9:07 am UTC

I have set the DATA_PUMP_DIR to point to mapped drive using following command mentioned in the question earlier -

sql> create or replace directory DATA_PUMP_DIR as 'O:\expdpgmnew\';


That is why not necessary to specify in expdp command.


To Paresh

J. Laurindo Chiappa, October 04, 2019 - 12:13 pm UTC

Hello... Do you read the provided link ? Copying as is from it :

"As Windows 2003 has a changed access behavior compared to Windows 2000, the solution is a little restrict :

Don't use local drive letters for mapping network shares. Workaround is to use UNC locations directly, e.g. backup to \\B\share Since this is in fact an absolute location this is always the
same for any node in the network. So whether accessed from node A or node B, \\B\share is always the shared location on B."

SO, your DATAPUMP DIRECTORY must be '\\IPorhostname\sharename' and NOT 'O:\expdpgmnew\', I think : try it...

Regards,

Chiappa

more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Data Pump

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