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?
Importing Oracle12c database
importoracleoracle-12csqlplus
Related Question
- Oracle impdp – Importing file from remote server
- I am getting error ORA-03113 at the time of startup database.
- Unable to open database (Datafile corrupted)
- Linux – Import all csv files into a table oracle
- Linux – ORA-48108 / ORA-48140 / ORA-48187 – diagnostic_dest value error(s) – init files / control files
- Linux – Using SQL*Plus to connect to remote DB from local server, how to export a backup to the local server
- Oracle 12c – Logically There Is A Redo Group But Not Physically – Database Can’t Open
Best Answer
Looks like your oracle directory doesn't exists. You will need to log into the database, create a directory, and retry your import
And retry your import. Pending on the user you are using to do the import, you may need to grant read/write access.