Did you bounce the listener?

-----Original Message-----
From: Kathleen Hurlbert
[mailto:oracledba-ezmlmshield-x2435914.[Email address protected]
Sent: Wednesday, September 29, 2004 12:24 PM
To: LazyDBA Discussion
Subject: [Fwd: Re: UTL_FILE Problem]




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
>
>
>
>





--------
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


The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. If the reader of this message is not the intended recipient,
you are hereby notified that your access is unauthorized, and any review,
dissemination, distribution or copying of this message including any
attachments is strictly prohibited. If you are not the intended
recipient, please contact the sender and delete the material from any
computer.

Oracle LazyDBA home page