Re: UTL_FILE_DIR = * question

Sybrand Bakker wrote:
>
> 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/

Dunno about NT, but utl_file_dir = * on Unix does work - but as you said, it would be a sad sad idea to do it...

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"