Re: DIRECTORIES and BFILE problems

miotromailcarlos_at_netscape.net (Carlos) wrote in message news:<1de5ebe7.0503070106.6b1b623d_at_posting.google.com>...
> 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.

Ops!
Wrong copy-and-paste! (from different windows to test it)

The real output is

 DBMS_LOB.FILEEXISTS(BFILENAME('CARLOS','DUMMY.TXT'))

                                                   1

Cheers. Received on Mon Mar 07 2005 - 10:41:39 CST