ORA-39087: directory name DATA_PUMP_DIR is invalid

Admin — Tue, 28 Apr 2009 15:58:55 GMT

Hi,

I got the following error message when doing an impdp.

prod005:(ECOM01)/oracle/db03/ECOM01/EXPORTS > impdp parfile=imp_ecom.par

Import: Release 10.2.0.4.0 - 64bit Production on Tuesday, 28 April, 2009 17:00:44

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-39087: directory name DATA_PUMP_DIR is invalid

Problem is either 1 of two things:

1. The datapump directory doesn't exist

2. The user trying to import doesn't have read/write privilege to access the directory.

In my case this was my parfile:

userid=ecom/ecompassword
DIRECTORY=DATA_PUMP_DIR
dumpfile=ecom_from_QA_042809.dmp
logfile=imp_ecom_from_QA_042809.log
TABLE_EXISTS_ACTION=APPEND

I issued the following statment and then it went through successfully:

SQL> grant read,write on directory DATA_PUMP_DIR to ecom;

Also, just make sure that the DATA_PUMP_DIR exists.

Thanks,

FranklinFaces.com - Oracle & SQL Server Database Forums for all IT Professionals / Oracle Forum / ORA - Oracle Database Error Codes - Search via specific error codes. / ORA-30000 Through ORA-40273 / ORA-39087: directory name DATA_PUMP_DIR is invalid / Latest Posts

ORA-39087: directory name DATA_PUMP_DIR is invalid