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.