Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA - 39002 on ImpDp

CharlovOct 16 2009 — edited Apr 3 2012
Hi,

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
This post has been answered by ji li on Oct 16 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 1 2012
Added on Oct 16 2009
4 comments
19,503 views