i am using Oracle 12c in debian Jessie i want to import an old database exported with expdp on oracle 12c when i try to launch the commande 'impdp' i got those errors : 'ORA-39002: invalid operation' 'ORA-39070: Unable to open the log file' 'ORA-39087: directory name DUMPS is invalid' Can you help me please?

1 Answer 1


Looks like your oracle directory doesn't exists. You will need to log into the database, create a directory, and retry your import

export ORACLE_HOME=/path/to/oracle/home
sqlplus / as sysdba
create directory DUMPS as '/path/to/your/dump/files';

And retry your import. Pending on the user you are using to do the import, you may need to grant read/write access.

  • You may want to mark your other post as answered as well, if this is the same issue.
    – Gandolf989
    Commented Apr 27, 2016 at 17:34

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.