flemingdg and I work for the same company. We install Oracle at multiple remote sites, we turn on Archive log and instruct the local admins to purge the archive log files on a regular basis. They don't always do that. We are trying to create some kind of procedure to automatically delete the archive logs that are older then 30 days. We would want to run some kind of pl/sql procedure on a regular interval which would look at the right table, delete the archive log and maybe even the record pointing to the file. I know that pl/sql is limited in file handleing so I thought about writing a dos command file that accepted a file name as an input and deleted it. But I'm not sure how to run an external command in pl/sql. Any thoughts or help on managing this process would be appreciated.

Thanks.