Utl_file.fremove and Windows
Date: Wed, 1 Jul 2009 15:58:32 -0400
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 10.2.0.3 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.
KenReceived on Wed Jul 01 2009 - 14:58:32 CDT