ORA-39087: directory name DATA_PUMP_DIR is invalid
FranklinFaces.com
FranklinFaces.com - Oracle & SQL Server Database Forums for all IT Professionals
 Home          Members     Calendar     Who's On

Welcome Guest ( Login | Register )
        



ORA-39087: directory name DATA_PUMP_DIR is... Expand / Collapse
Message
Posted 4/28/2009 3:58:55 PM Post #119
 

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being
Hi,

I got the following error message when doing an impdp.

prod005ECOM01)/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

Copyright (c) 2003, 2007, Oracle.  All rights reserved.

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,

 

« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: silencer

Permissions Expand / Collapse

All times are GMT -5:00, Time now is 7:14am

Powered By InstantForum.NET v4.1.4 © 2010
Execution: 0.075. 7 queries. Compression Disabled.