Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » oracle l »

ORA-29285: file write error

raja rao

2006-06-15

Replies:

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

©2008 dba.5341.com - Jax Systems, LLC, U.S.A.