This forum is currently locked. You can't register or post questions at this time. (read more)

expdp on network drive

All posts relating to Oracle database administration.

Moderator: Tim...

royalyogi
Senior Member
Posts: 181
Joined: Tue Apr 23, 2013 3:59 pm

expdp on network drive

Postby royalyogi » Tue Jul 23, 2013 1:00 pm

while try to expdp on network drive. getting below error.
Please let me know how can we perform the expdp on network drive

Network location: \\tsclient\p\expdp

1.)
SQL> show user
USER is "SYS"

SQL> create or replace directory exp as '\\tsclient\p\expdp';
Directory created.

SQL>Grant read,write on directory exp to system;

2.)
expdp system/xxxxx@orcl directory=exp dumpfile=EXP_orcl_072013.dmp logfile=EXP_72013_1.log schemas=('IIMS','CMMN')

Export: Release 11.2.0.2.0 - Production on Tue Jul 23 13:48:07 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Release 11.2.0.2.0 - 64bit Production
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 536
ORA-29283: invalid file operation

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: expdp on network drive

Postby Tim... » Tue Jul 23, 2013 3:09 pm

Hi.

Frits Hoogland wrote about something similar:

http://fritshoogland.wordpress.com/tag/ ... unc-share/

In his case the use of the UNC path, as you describe, worked fine.

I guess my first question is, is your path a public share, or dies it require authentication?

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

royalyogi
Senior Member
Posts: 181
Joined: Tue Apr 23, 2013 3:59 pm

Re: expdp on network drive

Postby royalyogi » Tue Jul 23, 2013 4:52 pm

Now It is working fine. Problem was OS level Privileges.
Thanks again

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: expdp on network drive

Postby Tim... » Tue Jul 23, 2013 5:25 pm

OK. :)

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog


Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 0 guests

cron