Tech Tip: Purge The Oracle Audit Trail
You can purge Unified Audit Trail by specifying last_arch_timestamp (If you don't want to purge all Unified Audit Record),BEGINDBMS_AUDIT_MGMT.SET_LAST_ARCHIVE_TIMESTAMP(audit_trail_type => DBMS_AUDIT_MGMT.AUDIT_TRAIL_OS,last_archive_time => TO_TIMESTAMP('10-SEP-0714:10:10.0','DD-MON-RRHH24:MI:SS.FF'));END;/BEGIN DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL(audit_trail_type => DBMS_AUDIT_MGMT.AUDIT_TRAIL_UNIFIED,use_last_arch_timestamp => TRUE);END;/
Related Articles
Discover articles that can help you grow your business.
The Role of JD Edwards in ESG
With organizations being held to higher standards, the importance of measuring ESG within the organization is quickly increasing.
Read More
Benefits of Using ERP Systems in Manufacturing: Part 3
There are extensive benefits of using ERP systems in manufacturing, impacting nearly every aspect of operations.
Read More
How ERP Systems Are Utilized in Manufacturing Companies Today: Part 2
In today’s fast-paced manufacturing environment, ERP systems are essential tools that integrate and streamline various business processes
Read More