dendenners
Programmer
Hi there,
I have a few pl/sql processes that create some files on the (aix) box that the database is installed on. I want the calling script to delete these files after remotely copying them. However, every file created by utl_file is owned by the oracle uid, and (in my case) has permissions rw-r--r--. Thus, unless I run the script as oracle (which I don't want to do) or root (ditto) I am unable to keep this particular directory clean. Does anybody know some way of dynamically changing the permissions on individual files generated by UTL_FILE, without messing with the oracle umask? Thanks a lot.
Denis
P.S. I have toyed with the idea of 'touch'-ing each file to be created by oracle prior to running the pl/sql, but there are some files whose names are dynamically assigned by pl/sql and which I don't know until after oracle has generated them.
I have a few pl/sql processes that create some files on the (aix) box that the database is installed on. I want the calling script to delete these files after remotely copying them. However, every file created by utl_file is owned by the oracle uid, and (in my case) has permissions rw-r--r--. Thus, unless I run the script as oracle (which I don't want to do) or root (ditto) I am unable to keep this particular directory clean. Does anybody know some way of dynamically changing the permissions on individual files generated by UTL_FILE, without messing with the oracle umask? Thanks a lot.
Denis
P.S. I have toyed with the idea of 'touch'-ing each file to be created by oracle prior to running the pl/sql, but there are some files whose names are dynamically assigned by pl/sql and which I don't know until after oracle has generated them.
