<i>etc/fstab</i>

10.100.52.12:/ftp /ftp nfs rw,bg,hard,nointr,rsize=1048576,wsize=1048576,tcp,vers=3,timeo=60,actimeo=0 0 0

# ll

drwxr-xr-x    6 root       1000     62 Mar 29 13:48 ftp

So I have to 'move' a file from this directory to a directory inside ACFS

    drwxrwxrwx 6 oracle oinstall  4096 Apr 10 09:34 ftp_files

 these instead are the priv (GRANTEE,TABLE_NAME,PRIVILEGE)

    PUBLIC FTP_IN READ

    PUBLIC FTP_IN WRITE

    DB_SCHEMA FTP_OUT READ

    DB_SCHEMA FTP_OUT WRITE

I execute this to move the files

    declare
    SRC        CONSTANT VARCHAR2(50) :=  'FTP_IN';
    DST        CONSTANT VARCHAR2(50) :=  'FTP_OUT';
    
    begin
         UTL_FILE.FRENAME(
           src_location => SRC,
           src_filename => 'test.txt',
           dest_location => DST,
           dest_filename => 'test.txt',
           overwrite => FALSE);
    end;

but it doesn't work, I get

    ORA-29292: file rename operation failed
    ORA-06512: a "SYS.UTL_FILE", line 348
    ORA-06512: a "SYS.UTL_FILE", line 1290
    ORA-06512: a line 6
    29292. 00000 -  "file rename operation failed"
    *Cause:    A file rename attempt was refused by the operating system
               either because the source or destination directory does not
               exist or is inaccessible, or the source file isn't accessible,
               or the destination file exists.
    *Action:   Verify that the source file, source directory, and destination
               directory exist and are accessible, and that the destination
               file does not already exist.

    -rw-r--r-- 1 oracle oinstall 0 Apr 10 14:47 test.txt