步骤如下:
SQL> exec dbms_audit_mgmt.init_cleanup(dbms_audit_mgmt.audit_trail_aud_std, 12);
PL/SQL procedure successfully completed.
SQL> begin
2 if dbms_audit_mgmt.is_cleanup_initialized(dbms_audit_mgmt.audit_trail_aud_std) then
3 dbms_output.put_line('initialized');
4 else
5 dbms_output.put_line('not initialized');
6 end if;
7 end;
8 /
PL/SQL procedure successfully completed.
SQL> exec dbms_audit_mgmt.clean_audit_trail(dbms_audit_mgmt.audit_trail_aud_std, false);
PL/SQL procedure successfully completed.
SQL> select count(*) from unified_audit_trail;
COUNT(*)
----------
4