7 Replies Latest reply on Dec 8, 2006 8:22 PM by JustinCave

    Data Pump impdp DIRECTORY object for dumpfiles on shared network drive

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