Oracle 12C -- 清空audit记录

时间:2023-03-09 22:32:13
Oracle 12C -- 清空audit记录

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);