ORA - 39002 on ImpDp
CharlovOct 16 2009 — edited Apr 3 2012Hi,
I am trying to import a dump to a newly created database on Red Hat Enterprise Linux AS release 4 (Nahant Update 3) Operating System
where an oracle 10G (10.2.0.1.0 ) is installed.
Database is fully operational but impdp is not working:
Error generated is the below:
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-39145: directory object parameter must be specified and non-null
ImpDp Command:
impdp uwave/wavemark remap_tablespace=users:WMRK_DATA DUMPFILE=expdp_ProdDB_2_LOCALDB.dmp LOGFILE=impdp_ProdDB_2_LOCALDB_rows_UWAVE.log PARFILE=impdp_ProdDB_2_LOCALDB_rows_UWAVE.par
I am located in the following directory:
/home/oracle/backup/import/data
Par Files and Dump Files are in the same directory where I am calling from the impdp.
I did my homework and researched the error and included the directory in the command:
So I moved the parfile to the import directory
And I am calling impdp from import as well
and my new command line is
impdp uwave/wavemark remap_tablespace=users:WMRK_DATA directory=data DUMPFILE=expdp_ProdDB_2_LOCALDB.dmp LOGFILE=impdp_ProdDB_2_LOCALDB_rows_UWAVE.log PARFILE=impdp_ProdDB_2_LOCALDB_rows_UWAVE.par
but I got this error
With the Partitioning, OLAP and Data Mining options
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-39087: directory name DATA is invalid
Directory data is valid. (i don t know why oracle showed is as caps in the error message)
and what about the log file?
Any input would be much appreciated