Re: Directory for CIFS folders on Windows

From: Vladimir M. Zakharychev <>
Date: Wed, 20 Feb 2008 05:18:17 -0800 (PST)
Message-ID: <>

On Feb 20, 2:31 pm, Thomas Sommerfeld <> wrote:
> Hello,
> I'm running an Oracle 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.
> 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

Patch to or upgrade to - 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"...


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

Original text of this message