Oracle 12C -- 清空audit记录
2015-12-07 17:22 abce 阅读(1077) 评论(0) 编辑 收藏 举报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);