Oracle UTL文件FRENAME ORA-29292

我有一个安装的目录如下:

etc/fstab

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
复制

但是，如果我只是尝试删除文件而不是将其删除为frename，则可以正常工作。
这可能是什么？

谢谢

最常见的原因是，顾名思义，“frename” 是严格的重命名，而不是移动。因此，如果您尝试 “重命名” 文件 * 跨 * 文件系统，那么这不太可能起作用。

例如

从/u01/dir1/file1重命名为/u01/dir2/file2将起作用 (如果 “/u01” 是已安装的文件系统)。

但是

从/u01/dir1/file1重命名为/u02/dir1/file1将不起作用 (如果 “/u01” 和 “/u02” 是不同的文件系统2)。