PL/SQL - UTL_FILE and Mapped Drives in NT

[Quoted] And you can get this to work in NT? I seem to have problems even though I've done everything below. Can someone confirm that on NT they are using UTL_FILE to read mapped _NETWORK_ drives (I have no problem with local drives). Are they in the same Domain? Did they use "Everyone" or "System" or what when creating the share. (I've tried all, by the way.)

Kent

In article
<newscache$km34zf$rak$1_at_lnews.actcom.co.il>,   "Bastiaan Schaap" <bschaap_at_desyde.nl> wrote:
> 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
[Quoted] > 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
[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
[Quoted] > > > 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
> >
> >
> >
> >
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Aug 12 2000 - 00:00:00 CEST