Re: Directory for CIFS folders on Windows

On Feb 20, 2:31 pm, Thomas Sommerfeld <TSommerf..._at_gmx.de> wrote:
> Hello,
>
> I'm running an Oracle 10.1.0.2.0 and Oracle XE on Windows maschines. Now
> I need to create several directory entries for folders on a network
> drive and afterwards to reference the files in a BFILE column.
> It's quite possible to create the directory, e.g.
> CREATE DIRECTORY LWZ as 'Z:\';
> or
> CREATE DIRECTORY LWZ as '\\ServerName\ShareName';
>
> And if I try to access files in this directory through the UTL_FILE
> package I'm also successful.
> But when I insert a record in my table and reference the file through
> BFILENAME('LWZ', 'MyFile.txt') the insert returns no error, but I'm not
> able to select the file through my table. (While an access to a file on
> the local hard disk is successful).
>
> Is there any possibility to create directories for network drives under
> Windows?
>
> Best regards
> Thomas
>
> --
> For answers by personal mail use: thomas.sommerfeld at domain ust-gmbh.de

Patch to 10.1.0.5.0 or upgrade to 10.2.0.2.0+ - they say these patchsets have the issue with UNC paths fixed. No fix for XE though as Oracle never created patchsets for it. Oh, and I suppose you made sure Oracle service runs under an account that can access those network shares and not under "Local System"...

Regards,

   Vladimir M. Zakharychev
   N-Networks, makers of Dynamic PSP(tm)    http://www.dynamicpsp.com Received on Wed Feb 20 2008 - 07:18:17 CST