I need a PL/SQL script which uses UTL_FILE to identify archive logs which can be deleted. I need to delete 30 day old archive log.
Printable View
I need a PL/SQL script which uses UTL_FILE to identify archive logs which can be deleted. I need to delete 30 day old archive log.
There is no way you could get this information using UTL_FILE. The only way to do this from the database is by using external functions/procedures or some database java functions/procedures.