ORA-29285: file write error

  • From: raja rao <raja4list@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 15 Jun 2006 08:20:18 -0700 (PDT)

Hi All,
   
  When my porgramme tries to write to a file using the  utl_file.putf ()
  it is writing only 15000 records only. and after that it is erroring out.
   
  I checked the mountpoint. it has lot of free space.
   
  i removed it and tried again, but same error:
   
  declare
*
ERROR at line 1:
ORA-29285: file write error
ORA-06512: at "SYS.UTL_FILE", line 18
ORA-06512: at "SYS.UTL_FILE", line 993
ORA-06512: at line 180
   
  the database is 9201 and solaris 9.
   
  is there any parameter i am missing here ?
   
  can someone help me ?
   
  Thanks in advance,
  RAj
   
   

 __________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

Other related posts: