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
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,