utl_file / nfs

[davey23uk]

Got a file on an NFS mounted directory which I am trying to use utl_file on to rename it to another NFS mounted directory

e.g. source directory

[xx1@xx1 in]$ ls -l
total 24

-rw-r--r--    1 550      its          4033 Jul  7 16:04 file1.xml

[xx@xx1 in]$ ls -ld
drwxrwxrwx    2 550      its          8192 Jul 11 12:25 .

Trying to move it to this directory

[xx@xx1 in]$ cd ../success/
[xx@xx1 success]$ ls -ld
drwxrwxrwx    2 550      its          4096 Jul 11 12:22 .

So the directories have full permissions on them. I am not the owner of the file nor am I in the same group but from the command line I can move the file using mv and the file gets moved

however when I try to do it using utl_file

I get an error

e.g.

declare
v_file varchar2(100);
v_direc constant varchar2(80) := 'IN_DIR';
v_direc2 constant varchar2(80) := 'SUCCESS_DIR';
begin
v_file := 'file1.xml';
utl_file.frename(v_direc, v_file, v_direc2, v_file);
end;
/

declare
*
ERROR at line 1:
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 18
ORA-06512: at "SYS.UTL_FILE", line 1108
ORA-06512: at line 7

Why cant utl_file move the file? If i give the file group write permission (the oracle user is in that group) then it works

What is utl_file.frename doing that is stopping this working unless the group permission is set.

Cheers

(9.2.0.5, redhat 2.1)