Re: PL/SQL - UTL_FILE

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

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

[Quoted] So in order to use a networked directory create a share for it which does [Quoted] [Quoted] NOT require ANY authentication, then map a drive to that directory or one of [Quoted] it's parent directories. As a final step you have to add the directory to [Quoted] the utl_file_dir entry in your parameter file. Remember that the database [Quoted] has to be restarted in order for the changes to take effect. [Quoted] We did this procedure on all common windows platforms, and it works like a [Quoted] charm. If you translate this to a unix environment I would say: make the [Quoted] [Quoted] share with Samba (or whatever Sun calls the SMB tools), then make a symbolic [Quoted] link for the share from the database machine to the network drive. Then you [Quoted] would have a directory entry on your root, that actually points to the [Quoted] 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/
[Quoted] tel. +31355411711

Michel Cadot <micadot_at_netcourrier.com> wrote in message [Quoted] 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 CEST