Tag Archives: ORA-39070

ORA-39002: invalid operation in Expdp Oracle

ORA-39002: invalid operation in Expdp

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 488
ORA-29283: invalid file operation

Error in Oracle EXPDB backup: directory path does not exist in Windows/Linux.

Solution:

Step 1: Check the directory specified in the expdp directory parameter:

expdp directory=dbbackup

Step 2: Log in as sysdba and verify the directory path:

Select * from dba_directories where directory_name = 'DBBACKUP';

Step 3: Confirm that the path from the queries is correct in Windows / Linux.