Env. Oracle 21C on Windows 10 Pro
I am getting the following error message when trying to perform a schema export:
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 536
ORA-29283: invalid file operation
Tried this script. Same result. I have checked the OS permissions and the users have read/write on the dump directory that definitely exists.
declare
f utl_file.file_type;
begin
f := utl_file.fopen ('DUMP_DIR', 'test.txt', 'w');
utl_file.put_line(f, 'test');
utl_file.fclose(f);
end;
/
Any help and/or suggestions greatly appreciated. Thanks!