Google it ....

Showing posts with label ORA-29283 expdp. Show all posts
Showing posts with label ORA-29283 expdp. Show all posts

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:

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.