ORA-39002: invalid operation ORA-39070: Unable to open the log file. ORA-29283: invalid file operation ORA-06512: at “SYS.UTL_FILE”, ORA-29283: invalid file operation

When doing export occur above error, let’s check directories:

SQL> select directory_name, directory_path from dba_directories

DIRECTORY_NAME     DIRECTORY_PATH

——————————————————————————–

DUMP_DIR       /u02/dump_dir

Two thing’s that hadn’t done is:

1) given correct permissions for that user to acccess the logical directory for export:

SQL> GRANT read, write on directory dump_dir TO ika; <-- username

2) create the physical directory

[oracle@oel6]$ mkdir -p /u02/dump_dir

After that our export run successfully;

I hope this article helped you. Your suggestions/feedback are most welcome.

Keep learning... Have a great day!!!