Google it ....

Thursday, February 27, 2014

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 with expdp occur next error:
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
Solution is simple let's check directories:

Here is video of these procedures - ORA-39002: invalid operation ORA-39070: Unable to open the log file

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.

5 comments:

  1. i am also doing this but not succeeded below is the 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

    ReplyDelete
  2. check if oracle directory object exist and also check if physically directory exist on host

    ReplyDelete
  3. I have this error when I want to export the database hr ....full database jobs require privileges...help me please

    ReplyDelete
  4. If you want to export full database use system user or grant your user exp_full_database role

    ReplyDelete
  5. thank you for sharing, it helped me solve my problems

    ReplyDelete