Hi Deepak, we use UTL file successfully, can the Oracle database owner
write to the directory?

Kathleen
Oracle DBA,
NOAA Fisheries, Seattle

Deepak Panda wrote:

>Hi Gurus,
>
>I am having a problem with UTL_FILE package while opening a file. I am using Oracle 9i DB on W2K box. I have done the following....
>
>1> set the utl_file_dir in the initSID.ora file.
>2>created the directory on the system.
>3>granted read access to the desired user on the directory.
>
>When I try to open a file from that directory it throws the exception.
>
>ORA-29280: invalid directory path
>
>Kindly point out the things that i might be missing.
>
>Thanks in advance
>
>Regards
>
>Deepak
>
>
>
>--------
>website: http://www.LazyDBA.com
>Please don't reply to RTFM questions
>Oracle documentation is here: http://tahiti.oracle.com
>To unsubscribe: see http://www.lazydba.com/unsubscribe.html
>To subscribe: see http://www.lazydba.com
>By using this list you agree to these terms:http://www.lazydba.com/legal.html
>
>
>
>




Oracle LazyDBA home page