1.使用job清空
SQL> dbms_audit_mgmt.create_purge_job
(
audit_trail_type=> DBMS_AUDIT_MGMT.AUDIT_TRAIL_UNIFIED,
audit_trail_purge_interval=>12,
audit_trail_purge_name=>'audit_trail_pj',
use_last_arch_timestamp=>TRUE,
container=>dbms_audit_mgmt.container_current);
2.手动清空
SQL> dbms_audit_mgmt.clean_audit_trail(audit_trail_type=>dbms_audit_mgmt.audit_trail_unified);