How to Truncate, Delete, or Purge Rows from the Audit Trail Table SYS.AUD$

个人总结

在10gR2以后如果不用DBMS_AUDIT_MGMT这个包管理审计信息的话.全语句直接操作SYS.AUD$表就行. 按照自己参考的工作文档,记得将SYS.AUD$表移出system表空间就行.

How to Truncate, Delete, or Purge Rows from the Audit Trail Table SYS.AUD$ [ID 73408.1]
		Modified 11-SEP-2010     Type BULLETIN     Status PUBLISHED

Applies to:

Oracle Server - Enterprise Edition - Version: 8.1.7.4 to 11.2.0.1 - Release: 8.1.7 to 11.2
Information in this document applies to any platform.
Checked for relevance on 11-Sep-2010

Purpose

This document explains how to purge, truncate, or delete rows from the audit trail table SYS.AUD$. Starting with Oracle 10gR2 it is possible to use package DBMS_AUDIT_MGMT for this. More information about this package can be read in Note 731908.1 -New Feature DBMS_AUDIT_MGMT To Manage And Purge Audit Information.

Scope and Application

This document is intended for DBA's or Oracle Support Analysts.

How to Truncate, Delete, or Purge Rows from the Audit Trail Table SYS.AUD$

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/11780477/viewspace-705352/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/11780477/viewspace-705352/