Re: UTL_FILE..Problem while accessing mapped files
Date: 2000/08/01
Message-ID: <8m55c1$pgk$1_at_nnrp1.deja.com>#1/1
Hi,
I have not tried this on NT but on HP-UX. I was having same problem as you. I would suggest to get administrative access to shared drive as well your NT userid should be part of DBA group. In UNIX when DBA ran the same procedure it worked ok but as a user it did not even I had access to directory.
I guess this helps..
Kedar
In article <416EDB2D12C9D311B8AD00508B8BFA4B15D37F_at_ORIGINWEB1>,
Makarand.Natu_at_originindia.com (Makarand Natu) wrote:
> This message is in MIME format. Since your mail reader does not
understand
> this format, some or all of this message may not be legible.
>
> ------_=_NextPart_001_01BFFAF1.AB778ED0
> Content-Type: text/plain
>
> Hi,
>
> I'm running Oracle 8.0.5 on NT-4 (SP3) on Server (#1). I have mapped
E:\ to
> a directory on another NT server (#2) on which I have some files
stored. I
> need to access files in this directory.
> But when I try to read any file on this mapped directory using FOPEN
> procedure, INVALID_OPERATION exception is raised.
> I checked the privileges on E:\ and they are ok.
> I tried using both the notations "E:\" and "E:" in the path argument
of
> FOPEN i.e. FOPEN('E:\','f1.dat','R') and FOPEN('E:','f1.dat','R') but
to no
> avail. Its not working.
> I have also specified these paths in the parameter UTL_FILE_DIR in
init.ora
> file.
> I'm totally stuck on what the problem is?
> Is it something I'm missing. Please suggest ASAP.
>
> TIA,
> Makarand.
>
> ------_=_NextPart_001_01BFFAF1.AB778ED0
> Content-Type: text/html
> Content-Transfer-Encoding: quoted-printable
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
> <HTML>
> <HEAD>
> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
> charset=3Dus-ascii">
> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
> 5.5.2650.12">
> <TITLE>UTL_FILE..Problem while accessing mapped files</TITLE>
> </HEAD>
> <BODY>
>
> <P><FONT FACE=3D"Arial">Hi,</FONT>
> </P>
>
> <P><FONT FACE=3D"Arial">I'm running Oracle 8.0.5 on NT-4 (SP3) on =
> Server (#1). I have mapped E:\ to a directory on another NT server
(#2) =
> on which I have some files stored. I need to access files in this =
> directory. </FONT></P>
>
> <P><FONT FACE=3D"Arial">But when I try to read any file on this
mapped =
> directory using FOPEN procedure, INVALID_OPERATION exception is
raised. =
> </FONT>
> <BR><FONT FACE=3D"Arial">I checked the privileges on E:\ and they are
=
> ok. </FONT>
> <BR><FONT FACE=3D"Arial">I tried using both the notations =
> "E:\" and "E:" in the path argument of FOPEN i.e.
=
> FOPEN('E:\','f1.dat','R') and FOPEN('E:','f1.dat','R') but to no
avail. =
> Its not working. </FONT></P>
>
> <P><FONT FACE=3D"Arial">I have also specified these paths in the =
> parameter UTL_FILE_DIR in init.ora file. </FONT>
> <BR><FONT FACE=3D"Arial">I'm totally stuck on what the problem is? =
> </FONT>
> <BR><FONT FACE=3D"Arial">Is it something I'm missing. Please suggest =
> ASAP. </FONT>
> </P>
>
> <P><FONT FACE=3D"Arial">TIA, </FONT>
> <BR><FONT FACE=3D"Arial">Makarand.</FONT>
> </P>
>
> </BODY>
> </HTML>
> ------_=_NextPart_001_01BFFAF1.AB778ED0--
>
> --
> Posted from [203.197.19.5]
> via Mailgate.ORG Server - http://www.Mailgate.ORG
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Tue Aug 01 2000 - 00:00:00 CEST