Data Pump impdp DIRECTORY object for dumpfiles on shared network drive
32360Dec 8 2006 — edited Dec 8 2006Our customer has delivered Data Pump dumpfiles to a Linux Server where Oracle is not installed. We are attempting to use impdp from a Windows 2003 Server with Oracle release 10.2.0.3 installed. The following steps have been taken:
1) Established a DIRECTORY object DATA_PUMP_DIR and verified that it works
2) Used "Map Network Drive" to create a connection to the shared file folder on the Linux Server and verified that I could see the files from Windows
3) Established a DIRECTORY object YETI for the mapped network drive
4) To test that the dumpfile itself was readable, copied one to the Windows Server and was able to use impdp against it.
5) Had the Windows Network Admin give all privileges to everyone on the Linux shared file folder
The command line and ensuing errors are below:
impdp system/mypassword DIRECTORY=DATA_PUMP_DIR DUMPFILE=YETI:DATAMART131.DP_DMP
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Produc
tion
With the Partitioning, OLAP and Data Mining options
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31640: unable to open dump file "\\Yeti\Temp\johnsdata\DATAMART131.DP_DMP" for read
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 1326) Logon failure: unknown user name or bad password.