Re: UTL_FILE_DIR = * question

AFAIK this is NOT going to work. You need to list individual directories separated by ; Also, it would be extreemly bad practice to allow the server to write anywhere.

Regards,

Sybrand Bakker, Oracle DBA

<cwang9_at_yahoo.com> wrote in message news:91evb2$9tb$1_at_nnrp1.deja.com...
> Thanks, Faheem
> ,
>
> I did restarted the instance,, I have only one default
> instance.
>
> Is the UTL_FILE pkg available to all instances,
> all schemas?? I could vaguely recall some posted
> message about enabling the UTL_FILE pkg somehow,,,
>
> Once again I am running Oracle8i/Linux ...
>
>
> thanks,
>
> Jack_at_Tampa
> Seurat Company
> =====================
>
>
> In article <91e862$p3g$1_at_nnrp1.deja.com>,
> faheemrao_at_my-deja.com wrote:
> >
> >
> > Did you restart your instance ???
> >
> > Faheem Rao
> >
> > In article <91e45n$lp9$1_at_nnrp1.deja.com>,
> > cwang9_at_yahoo.com wrote:
> > > All:
> > >
> > > I got "Invalid Path ..." error when I tried to READ a
> > > Unix text file. I am running Oracle8i on my home PC.
> > >
> > > Then I updated the init.ora file and added this line:
> > >
> > > UTL_FILE_DIR = *
> > >
> > > This should add all directories to its access list. However
> > > I got the exact same "Invalid Path ..." error,,,
> > >
> > > Anything I missed ???
> > >
> > > Thanks,
> > >
> > > Jack_at_Tampa/FL
> > >
> > > Sent via Deja.com
> > > http://www.deja.com/
> > >
> >
> > Sent via Deja.com
> > http://www.deja.com/
> >
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Sat Dec 16 2000 - 00:38:53 CST