12C 删除统一审计信息

步骤如下:

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