Tag Archives: expdp/impdp Data Pump Error

How to Sovle expdp/impdp Data Pump Error

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production
With the Partitioning, OLAP, Data Mining 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

Cause: Oracle failed to read the default backup directory

Solution:

1. Recreate the logical directory with an administrator such as system (if you want to have the same name as the original logical directory, you need to delete the directory and recreate it first)

Create directory mydata as’ logical directory path ‘;

For example: create directory mydata as’/data/Oracle/mydata ‘;

Delete directory:   drop directory   mydata

2. Check whether the logical directory is created successfully

select * from dba_directories

3. Re expdp export or impdp import data. If the default logical directory used before needs to specify the directory

impdp system/ ddddd@orcl remap_schema=mydb:testdb   directory=mydata DUMPFILE=data1.dmp table_exists_action=replace