Utl_file.fremove and Windows

From: Kenneth Naim <kennaim_at_gmail.com>
Date: Wed, 1 Jul 2009 15:58:32 -0400
Message-ID: <00a601c9fa86$52135490$f639fdb0$_at_com>

This post is more of an FYI rather than a question, just in case anyone runs into the issue in the future.  

I am running on on windows and had cause to write and later remove a file on remote server (also windows). I set up the directory using the unc path \\servername\events, granted the privileges within oracle. Set up the windows directory granted the appropriate privileges on it as well. Wrote a simple package to write the file and it worked without issue. The remove file failed however with an ORA-29283 with gives no details whatsoever. I played with the permissions, changing the windows directory name to be all lowercase to match the directory as defined in oracle all without success. As a guess I modified the directory to use the fully qualified server name \\servername.doman\events, and low and behold it worked. Both servers are in the same domain. I'm not sure if this an oracle issue, or a network issue but it is strange.  

In summary, to write a file to the server a domain name was not required but to remove the file a domain name was required.  

Any comments are welcome.  


Received on Wed Jul 01 2009 - 14:58:32 CDT

Original text of this message