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!

impdp unable to open log file

25419Dec 8 2006 — edited Dec 8 2006

I have installed Oracle10Rel2 on a Windows 2000 server. I managed to get an
expdp from a machine but trying to do import I keep getting an error about writing
a log file. What else do I need to set? I even tried setting my directory value to
the location I have UTL_FILE_DIR set to for other processes. Even with Nologfile
specified it says it cannot write it.

Set Data_pump_dir=d:\log_err
expdp jlim/jlimdba01@emtsdb3 dumpfile=export_initial.dmp schemas=MYUSER

impdp jlim/jlimdba01@msgsup2 DUMPFILE=export_initial.dmp NOLOGFILE

Ora-39002: invalid operation
Ora-29070: Unable to open the log file.
Ora-39-087: directory name d:\log_err is invalid.

I am in the directory even.

I am trying to determine if Expdp only schema=Myuser gets everything I used to
get when I exported the User in Oracle 9i including grants, procedures, packages,
and things created by the owner.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 5 2007

Added on Dec 8 2006

#general-database-discussions

9 comments

4,606 views