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!

impdp error ORA-39002: invalid operation ORA-39070: Unable to open the log file. ORA-29283: invalid

2924251Apr 5 2015 — edited Apr 6 2015

Hello Friends,

I am trying to import dump and when i am typing this command "impdp SYSTEM/Admin123@pdborcl directory=dpimport dumpfile=biapps_SA406.dmp logfile=biapps_SA406.log".

It throws an error --

Import: Release 12.1.0.1.0 - Production on Sun Apr 5 04:09:57 2015

UDI-28002: operation generated ORACLE error 28002

ORA-28002: the password will expire within 0 days

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

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

can any one help me out to solve the problem. Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on May 4 2015

Added on Apr 5 2015

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

3 comments

8,089 views