Purge audit trail that are older than "n" days in 11g r2
hongfengNov 22 2010 — edited Nov 22 2010Hi,
In 11g R2, you can purge the audit trail using procedures in dbms_audit_mgmt package. You can manually delete them or create a job (use CREATE_PURGE_JOB Procedure) to purge them periodically. The purge job can purge all the audit files ( when use_last_arch_timestamp parameter is set to FALSE) or audit files older than a specified date (when use_last_arch_timestamp is set to TRUE).
The "audit_trail" parameters is set to "XML" in my database. I intent to create a job to purge audit files when they are 7 days older. I cannot find anyway to configure it to do so. Either you purge all files or files are older than a specified date.
Any one can shed some light on this?
Thanks.