Re: DIRECTORIES and BFILE problems

Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote in message news:<0f6m215l2u12kf1oar3e2999i7i6fpq3jj_at_4ax.com>...
> On Sun, 06 Mar 2005 14:52:27 GMT, "JavaDeveloper" <developer_at_java.it>
> wrote:
>
> >Thanks at all of you.
> >I supposed that I had to have files on the db server to point at them
> >through a BFILE Object. I tried also to give a net directory path, like
> >\\mycomputer\files\, but It does not like it. Strange...
> >So, I'll consider to move all my files on the db server, or use a BLOB
> >Object. With these ones (BLOBs) I can't reach a net directory path like
> >\\mycomputer\files\ anyway!! Why? I can't to do this?
>
> Remote file systems are not supported by Oracle. You have to change a
> registry key to have the local administrator account act as a network
> administrator, having full access to all remote systems. There is a
> note to this effect on Metalink, which I unfortunately didn't
> bookmark, so I can't tell you which key it is.

>You have to change a registry key to have the local administrator
account act as a network administrator, having full access to all remote systems.

Not in my system (Oracle 9.2.0.4 on Win2K Server). In my case, the requisite is the user executing Oracle processes(services) must be an authenticated user in the domain, with visibility over the folder (remember, this is Windows) to be created as DIRECTORY.

In my system, the user executing Oracle processes(services) is NOT a network administrator.

Logged with an Oracle User with privileges required:

SQL> create or replace directory CARLOS AS '\\carlos\shared';

Directorio creado.

Created a dummy text file in the shared folder in the remote PC 'DUMMY.txt'.

SQL>select DBMS_LOB.FILEEXISTS (bfilename('CARLOS','DUMMY.txt')) from dual;

DBMS_LOB.FILEEXISTS(BFILENAME('JACLOPEZ','KK.TXT'))

                                                  1

( 1 => Physical file exists ).

Cheers. Received on Mon Mar 07 2005 - 03:06:59 CST