在下面的步骤前,先了解下这些选项的含义,由于我设置额db_extended所以在过程中我需要选择清除的对象为AUDIT_TRAIL_AUD_STD.
| Constant | Type | Value | Description |
|---|---|---|---|
AUDIT_TRAIL_ALL |
PLS_INTEGER |
15 | All audit trail types. This includes the standard database audit trail (SYS.AUD$ and SYS.FGA_LOG$ tables), operating system (OS) audit trail, and XML audit trail. |
AUDIT_TRAIL_AUD_STD |
PLS_INTEGER |
1 |
Standard database audit records in the SYS.AUD$ table |
AUDIT_TRAIL_DB_STD |
PLS_INTEGER |
3 |
Both standard audit (SYS.AUD$) and FGA audit(SYS.FGA_LOG$) records |
AUDIT_TRAIL_FGA_STD |
PLS_INTEGER |
2 |
Standard database fine-grained auditing (FGA) records in the SYS.FGA_LOG$ table |
AUDIT_TRAIL_FILES |
PLS_INTEGER |
12 | Both operating system (OS) and XML audit trails |
AUDIT_TRAIL_OS |
PLS_INTEGER |
4 | Operating system audit trail. This refers to the audit records stored in operating system files. |
AUDIT_TRAIL_XML |
PLS_INTEGER |
8 | XML audit trail. This refers to the audit records stored in XML files. |
begin DBMS_AUDIT_MGMT.SET_LAST_ARCHIVE_TIMESTAMP ( audit_trail_type => DBMS_AUDIT_MGMT.AUDIT_TRAIL_FGA_STD, last_archive_time => sysdate - 7 ); end; / begin DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL ( audit_trail_type => DBMS_AUDIT_MGMT.AUDIT_TRAIL_FGA_STD, use_last_arch_timestamp => true ); end; /