Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Purge audit trail that are older than "n" days in 11g r2

hongfengNov 22 2010 — edited Nov 22 2010
Hi,

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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 20 2010
Added on Nov 22 2010
3 comments
4,756 views