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.
i am also doing this but not succeeded below is the error
ReplyDeleteORA-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
check if oracle directory object exist and also check if physically directory exist on host
ReplyDeleteI have this error when I want to export the database hr ....full database jobs require privileges...help me please
ReplyDeleteIf you want to export full database use system user or grant your user exp_full_database role
ReplyDeletethank you for sharing, it helped me solve my problems
ReplyDelete