Avatar of ET_VB
ET_VB
 asked on

Data Pump Import: can I map an oracle directory object to a shared directory residing on a remote box?

Oracle DB 10.2.0.3   /  Windows 2003:

Seek to DATA PUMP IMPORT from dumpfiles residing on USB HD connected to local workstation.  Have shared the directory containing DATA PUMP EXPORT dumpfiles on connected USB HD so that it is read/write to users on remote DB server.  On remote DB server, I have mapped the visible USB HD share as 'Q' drive.  Created an Oracle DIRECTORY OBJECT called 'xDump' to reference the 'Q' drive and a DIRECTORY OBJECT called 'zDump' to reference a local directory on the DB server to house import logs.

Issue following DATA PUMP IMPORT command

>impdp schemas=www,zzz parallel=5 dumpfile=xDump:schema_%U.dmp logfile=zDump:schema_import.log

I get the following (generalized) errors:

39001:  invalid argument value
39000:  bad dump file specification
31640:  unable to open dumpfile 'Q:\xDump\SCHEMA_01.dmp' for read
27041:  unable to open file
O/S Error:  (OS3)  system cannot find path specified

I assume Oracle Directory Objects can only reference local drives and not mapped network shares as I have attempted.  Please share your expertise.

v/r
Oracle Database

Avatar of undefined
Last Comment
ET_VB

8/22/2022 - Mon
David VanZandt

I believe that the syntax is DIRECTORY=xDUMP -- one cannot specify either xDump nor zDump as part of a parameter's value.
ASKER CERTIFIED SOLUTION
ET_VB

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck