Re: UTL_FILE_DIR = * question

From: <faheemrao_at_my-deja.com>
Date: Mon, 18 Dec 2000 08:24:20 GMT
Message-ID: <91khjh$796$1@nnrp1.deja.com>

Dear Sybrand

Yo have said that ,

UTL_FILE_DIR = * is not going to work,
But I think it should work.
Can you give me reason that , why it will not work.

Faheem Rao

In article <3A3B2544.7258_at_yahoo.com>,
  connor_mcdonald_at_yahoo.com wrote:
> 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"
>

Sent via Deja.com
http://www.deja.com/ Received on Mon Dec 18 2000 - 02:24:20 CST