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

On Feb 20, 2:31 pm, Thomas Sommerfeld <TSommerf... (AT) gmx (DOT) de> wrote:
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

On Feb 20, 2:31 pm, Thomas Sommerfeld <TSommerf... (AT) gmx (DOT) de> wrote:
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

On Feb 20, 2:31 pm, Thomas Sommerfeld <TSommerf... (AT) gmx (DOT) de> wrote:
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

On Feb 20, 2:31 pm, Thomas Sommerfeld <TSommerf... (AT) gmx (DOT) de> wrote:
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

Vladimir M. Zakharychev schrieb:

it seems not to work even with 20.2.0.3. But I found a workaround which
is fine for me. For my purpose I just want to index a list of files with
Oracle Text and in this case it's possible to index the column with the
filename pointing to a remote network share by using the FILE_DATASTORE.

Thanks for your help
Thomas

--
For answers by personal mail use: thomas.sommerfeld at domain ust-gmbh.de

Vladimir M. Zakharychev schrieb:

it seems not to work even with 20.2.0.3. But I found a workaround which
is fine for me. For my purpose I just want to index a list of files with
Oracle Text and in this case it's possible to index the column with the
filename pointing to a remote network share by using the FILE_DATASTORE.

Thanks for your help
Thomas

--
For answers by personal mail use: thomas.sommerfeld at domain ust-gmbh.de

Vladimir M. Zakharychev schrieb:

it seems not to work even with 20.2.0.3. But I found a workaround which
is fine for me. For my purpose I just want to index a list of files with
Oracle Text and in this case it's possible to index the column with the
filename pointing to a remote network share by using the FILE_DATASTORE.

Thanks for your help
Thomas

--
For answers by personal mail use: thomas.sommerfeld at domain ust-gmbh.de

Vladimir M. Zakharychev schrieb:

it seems not to work even with 20.2.0.3. But I found a workaround which
is fine for me. For my purpose I just want to index a list of files with
Oracle Text and in this case it's possible to index the column with the
filename pointing to a remote network share by using the FILE_DATASTORE.

Thanks for your help
Thomas

--
For answers by personal mail use: thomas.sommerfeld at domain ust-gmbh.de