Re: UTL_FILE_DIR

> With Win32, Your UTL_FILE_DIR can list ANY path accessible from the
> server, i.e :
>
> Your DB resides on server1.
>
> You have a directory 'c:\oraclestuff' on server2, which you want your
> DB on server1 to acces.
>
> You share 'c:\oraclestuff' with, say, sharename oracle$ and then you
> map that share on server on with, say, driveletter O:.
>
> Now add O:\ to your UTL_FILE_DIR list in your init.ora and you are
> done.

Morning all,

I think the above may not work as I'm almost 100% certain that Oracle cannot access shares using UTL_FILE. In fact, I'm so sure (cue downfall) that I wrote a couple of UTL_FILE FAQ answers (based on real life testing) over on the Co-operative FAQ. The one describing shares is at :

http://www.jlcomp.demon.co.uk/faq/utl_file.html

Down near the bottom there is a bit about shares and networked drives - that may prove helpful.

Cheers,
Norm.

-- 
Delete the obvious bit from my email address to reply by email.