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 operationSolution is simple 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, remember that in linux characters are different with uppercase and lowercase
[oracle@oel6]$ mkdir -p /u02/dump_dir
after that our export run successfully.