This content has been marked as final. Show 5 replies
How about the following command:
chmod a+w filename
You can also redefine umask at the command prompt prior to creating the file, i.e.
then create the file.
Yes, I scheduled permission command but we need in real time as files are lot more than 1000 per hour.
These files been created by a procedure over util process, let me test umask 0000 and revert.
Perhaps it would be a better idea to fix or modify the program that creates all these files.
thanks dude, any guideline for pl/sql procedure change, below is sample for file creation
CREATE DIRECTORY test_dir AS 'c:\';
-- CREATE DIRECTORY test_dir AS '/tmp';
fileHandler := UTL_FILE.FOPEN('test_dir', 'test_file.txt', 'W');
UTL_FILE.PUTF(fileHandler, 'Writing TO a file\n');
WHEN utl_file.invalid_path THEN
raise_application_error(-20000, 'ERROR: Invalid PATH FOR file.');
I think the SQL and PL/SQL at PL/SQL and SQL might be a better place to post questions about PL/SQL procedures.
You should also find some useful info searching in Google for "utl_file umask".
What I was thinking is to change the procedure that calls the function that actually creates the 1000 files per hour.