Oracle 12c : How To Purge The UNIFIED AUDIT TRAIL
Oracle 12c : How To Purge The UNIFIED AUDIT TRAIL APPLIES TO: Oracle Database - Enterprise Edition - Version 12.1.0.1 and later Information in this document applies to any platform. GOAL How to purge the UNIFIED_AUDIT_TRAIL table ? SOLUTION The unified audit trail can be purged using the DBMS_AUDIT_MGMT package: qlplus / as sysdba SQL> select count(*) from unified_audit_trail; COUNT(*) ---------- 2619 SQL> BEGIN DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL( audit_trail_type => DBMS_AUDIT_MGMT.AUDIT_TRAIL_UNIFIED, use_last_arch_timestamp => FALSE); END; / PL/SQL procedure successfully completed. SQL> select count(*) from unified_audit_trail; COUNT(*) ---------- 1 You can also use the last_arch_timestamp, if you don't want to purge all ...
I have a career opportunity for a talented Oracle & SQL DBA based in Cape Town South Africa with one of our Petrochemical clients. Please contact me at zarina@siyayarecruits.co.za for more information.
ReplyDeleteit is my pleasure to apply..
ReplyDeletealternativly contact me on
bhavesh.oradba@gmail.com