Database Software

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!

error in impdp

DIVINov 29 2012 — edited Nov 29 2012

I have a dump file exported from another machine, now i need to import it into my machine and i followed below steps

Step1(at sql prompt) : create or replace directory my_dir as 'D:\my_dir'; grant read,write on DIRECTORY my_dir to public; and place my dump file in my_dir
Step2 (at command prompt): impdp username/password@schemaname directory=my_dir dumpfile=mydump.DP.DMP

i am getting the below error

ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 536
ORA-29283: invalid file operation

what could be the problem ? ? ?

Edited by: DIVI on Nov 29, 2012 2:28 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 27 2012

Added on Nov 29 2012

#database-key-features, #export-import-sql-loader-external-tables

7 comments

1,007 views