OCP Blog
Super DBA
ORA-39002: invalid operation ORA-39070: Unable to open the log file
by vazha mantua Tuesday, December 18, 2012 2:30 PM

Hello All,

 

Today we resolved problem with 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 536
ORA-29283: invalid file operation

This error we got when use ASM file system as directory. expdp can’t create log file on ASM disk storage.

For avoiding creating expdp log file on ASM use second directory with standard  file system

Solution :

create directory EXPDP_LOG as '/u0/app/oracle/logs'

and use expdp parameter LOGFILE=EXPDP_LOG :exp_dbh.log

Comments (1) -

2/16/2013 3:40:25 PM #

thesis ideas

The concept of your blog is really very informative. I definitely share your views to my close friends keeps up the good work going.
<a href="dissertation-topics-examples.info/">thesis ideas</a>

thesis ideas United Kingdom

Add comment

  Country flag

biuquote
  • Comment
  • Preview
Loading

Filter by APML

Calendar

<<  August 2018  >>
MoTuWeThFrSaSu
303112345
6789101112
13141516171819
20212223242526
272829303112
3456789

View posts in large calendar

TextBox