Re: PL/SQL - UTL_FILE

From: Bastiaan Schaap <bschaap_at_desyde.nl>
Date: 2000/08/11
Message-ID: <newscache$km34zf$rak$1@lnews.actcom.co.il>#1/1

Depends on how you try to get onto the network drive. When accessing a network path there are 3 things to take into consideration:

1. You have to map a drive to the directory on the network
2. There must not be any authorization required to access that directory
3. The path must be in the UTL_FILE_DIR entry in your init<SID>.ora file

(oracle initialization parameters)

So in order to use a networked directory create a share for it which does NOT require ANY authentication, then map a drive to that directory or one of it's parent directories. As a final step you have to add the directory to the utl_file_dir entry in your parameter file. Remember that the database has to be restarted in order for the changes to take effect. We did this procedure on all common windows platforms, and it works like a charm. If you translate this to a unix environment I would say: make the share with Samba (or whatever Sun calls the SMB tools), then make a symbolic link for the share from the database machine to the network drive. Then you would have a directory entry on your root, that actually points to the network share. I haven't tried this unix setup yet, but I will sometime soon...

HTH, Bastiaan Schaap
Oracle web development,
Desyde BV - Baarn
http://www.desyde.nl/
tel. +31355411711

Michel Cadot <micadot_at_netcourrier.com> wrote in message news:8mto45$qdr$1_at_s1.read.news.oleane.net...
>
> Sybrand Bakker <postbus_at_sybrandb.demon.nl> a écrit dans le message :
> 965847547.24803.0.pluto.d4ee154e_at_news.demon.nl...
> > It's true and not true.
> >
> > the utl_file will run on your server (as all the pl/sql code).
> > So any directory reachable by the server can be used, though I never
 tried
> > NFS-mounted drive.
>
> I don't try On Unix, but it doesn't work on network drive on Windows NT.
>
> > The other way around should definitely work: you make an NFS-mount of
 the
> > drive designed by the DBAs for output, so you will have access to the
 output
> > written on the server.
> > It looks like they either lack knowledge or are not very cooperative.
> >
> > Hth,
> > Sybrand Bakker, Oracle DBA
> >
> >
> > S
> >
> > "Jenny Farnham" <farnham_at_spot.Colorado.EDU> wrote in message
> > news:8ms3jv$ct2$1_at_peabody.colorado.edu...
> > > Platform: Unix
> > >
> > > I have my PL/SQL code on one machine.
> > > The database is located on a server.
> > >
> > > I login to the database like this:
> > >
> > > sqlplus aaa/bbb_at_cfrptam
> > >
> > > I'm trying to use the UTL_FILE package,
> > > however, it will not work according to
> > > our DBA.
> > >
> > > They said because the database is on another
> > > machine I can not use the UTL_FILE package.
> > > Is that true? Is there a way around this?
> > >
> > > Thanks,
> > > Jennifer
> > > SUN Microsystems
> > >
> > >
> >
>
> --
> Have a nice day
> Michel
>
>
>
>
Received on Fri Aug 11 2000 - 00:00:00 CDT