Re: UTL_FILE_DIR

Hi Norman,

Point taken. Thanks for the hint.

• Kenneth Koenraadt

On Wed, 01 Oct 2003 11:42:52 +0000, "Norman Dunbar" <Norman_at_RE-MO-VE.BountifulSolutions.co.uk> wrote:

>> 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.
>
>
Received on Fri Oct 03 2003 - 12:13:05 CDT