Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: UTL_FILE_DIR failed on network drive ...
...additionally, i found that if you run Oracle under a user who has network
privs, they have to be logged into NT as well whilst you are performing your
UTL_FILE.
Alternatively, use the UNC file convention (e.g \\machine\share\file)
Metalink will explain more, havent got the Doc ID to hand though.
M
"Andre van Winssen" <andrew_at_info.nl> wrote in message
news:aaeov2$d1s$1_at_news1.xs4all.nl...
> Hi,
> the problem is that the Oracle NT service that the database is using
> has default os credentials of NT user system. This is a pure local os user
> who doesn't have any privileges to access network drives. The same problem
> occurs when trying to run Parallel Server on NT. In both cases the
solution
> for me
> was to let the OracleService<%ORACLE_SID%> service run under a different
> domain account with enough privileges to access drives from the network.
>
> Hth,
> Andre van Winssen
>
>
> "hubertus" <funfack_at_windhager.de> schreef in bericht
> news:a03492ba.0204260536.339b53c_at_posting.google.com...
> > Hi,
> >
> > writing on network-drives failed with utl_file_dir
> >
> > SERVER: W2K ORACLE: 8.1.6
> > ORA.INI: UTL_FILE_DIR = *
> > NETWORK-DRIVES: WINDOWS,SAMBA
> >
> > writing to local drives via ORACLE does fine.
> > writing to network drives via notepad does fine.
> > writing to network drives via ORACLE (SQL-PLUS) failed.
> >
> > EXAMPLE:
> > declare f utl_file.file_type;
> > begin
> > f := utl_file.fopen('i:\','test.txt', 'W');
> > utl_file.fclose(f);
> > end;
> >
> > FAILURE:
> > declare f utl_file.file_type;
> > *
> > ERROR at line 1:
> > ORA-06510: PL/SQL: unhandled user-defined exception
> > ORA-06512: at "SYS.UTL_FILE", line 101
> > ORA-06512: at "SYS.UTL_FILE", line 157
> > ORA-06512: at line 3
> >
> > Does someone knows about this error ?
> >
> > Tanks
> > Hubertus
>
>
Received on Sat Apr 27 2002 - 14:45:57 CDT