OraFAQ Forum: Server Administration » UTL

Home » RDBMS Server » Server Administration » UTL_FILE Remote path in win NT

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

UTL_FILE Remote path in win NT [message #53774]

Thu, 10 October 2002 08:57

Fabio
Messages: 23
Registered: October 2001

Junior Member

Hi,
I wanted to know if it is possible (under NT) to
open a remote file specified with a distributed
file system pathname, using the package utl_file
e.g
- utl_file.fopen('\hostC$abc');
OR
- utl_file.fopen('G:');

where "G" is a remote drive earlier connected on the db server

I've run some tests but it doesn't seem to work.
The problem seems to be the privilege on the remote directory.

Report message to a moderator

Re: UTL_FILE Remote path in win NT [message #53777 is a reply to message #53774]

Thu, 10 October 2002 09:05

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

UTL_FILE is a server side script.
it can createread a file only in the machine where database resides.
a network shared drive etc wont be effective.

Report message to a moderator

Re: UTL_FILE Remote path in win NT [message #53780 is a reply to message #53774]

Thu, 10 October 2002 14:15

andrew again
Messages: 2577
Registered: March 2000

Senior Member

Although I haven't tried, you could try creating a shortcut in a local drive. Hopefully ult_file can follow the link. I'm sure it can follow soft links in unix.

Report message to a moderator

Previous Topic:	Re: UTL_FILE: can open remote file ??
Next Topic:	Error occured when doing recovery

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 17:03:55 CDT 2024