This doesn't seem to work
Luis, November 01, 2022 - 1:17 pm UTC
Hi,
I am posting this reply as I got referred to this suggestion on a support SR, and after testing the ACL it does not seem to work for DBMS_FILE_TRANSFER.
$ setfacl -d -m o::r .
$ getfacl .
# file: .
# owner: oradb01
# group: oinstall
user::rwx
group::r-x
other::r-x
default:user::rwx
default:group::r-x
default:other::r--
$ rm copia.txt
-- Ran the copy a SQL session
CREATE OR REPLACE DIRECTORY teste03 AS
'/home/oradb01/teste3';
begin
DBMS_FILE_TRANSFER.COPY_FILE(
'TESTE02','teste.txt','TESTE03','copia.txt');
END;
$ ls -l
total 0
-rw-r----- 1 oradb01 oinstall 0 Nov 1 09:42 copia.txt
$
Regards,
Luis
November 02, 2022 - 5:01 am UTC
Is the file an exact multiple of 512bytes?