Re: UTL_FILE to another host?

Marc wrote:
>
> Two WIN2K Servers
> Oracle 8.1.7.2.1
>
> Can I create a flat file in a directory located on another server? The
> directory of the target host is set to have full access to everyone. I
> specified a list of exceptions, and I get an INVALID_OPERATION error.
>
> Any ideas?
>
> Marc

Typically you can get it to work if you use a UNC name rather than a mapped drive (since the drive may not have been mapped when Oracle started). Also look at starting Oracle services under a particular account which has access to the remote server

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."