| EXPDP to remote Windows directory [message #464400] |
Wed, 07 July 2010 16:09  |
estolts
Messages: 6
Registered: April 2009
Location: San Antonio
|
Junior Member |
|
|
Due to local disk space issues, I am attempting to expdp (full export to a .dmp file) to a remote Windows backup server directory.
I have created oracle directory paths (i.e \\backupserver\f$\CCPSP, \\backupserver\f:\CCPSP) and also mapped a drive (Z:\CCPSP) all connecting to the backup server w/ read, write permissions granted.
All these attempts failed w/ the following error:
Connected to: Oracle Database 10g Release 10.2.0.4.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 488
ORA-29283: invalid file operation
Is there a way to trick or steps to follow in allowing expdp to write to a .dmp on a remote windows server?
|
|
|
|
|
|
| Re: EXPDP to remote Windows directory [message #464417 is a reply to message #464400] |
Thu, 08 July 2010 01:04  |
 |
Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
1/ Instance owner has almost always only rights on local server and not remote drive
2/ Check the privilege of this user
3/ Many Oracle server tools does not support UNC or mapped drive; I don't know if it is the case for datapump
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
