Hi,
I am having an common error "Data pump error "
With the following messages:
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 536
ORA-29283: invalid file operation
when I tried to export the dump data into the dump file using this command:
expdp hustudent/hsturpo_x1 dumpfile=hist_201310_201315_201317.dmp tables=as_stu_enr_sum_hist,sfbetrm_hist,sgrchrt_hist,sfrstcr_hist,sprintl_hist,sprhold_hist,saradap_hist logfile=hist_201310_201315_201317_exp.log directory=HISTORY_DUMP
I searched and found some fix for this error in different forums but none of the solutions I found helped me.
I tried to this solution here: Michael Wilson's Oracle DBA Blog: Data Pump Error - ORA-39070: Unable to open the log file
But it did not work for me.
I also tried to see if it was a permission issue. I found out that Oracle could not write to the directory. I know Oracle needs to write and read on the directory. it should be running export from /home01/student/hist_dump
cause i had set permissions on it for the student user.
This is what hist_dump was ...
drwxrwxr-x 3 student banner 512 Jan 29 14:52 hist_dump
Can someone see something I omitted or did not look at or know how to fix this issue, please?
Thanks In Advance