because I restarted the database anyway. For this I defined the following steps: Create a report of your audit trail (optional) Export your audit trail information for longterm archiving (optional) Set the archive timestamp as soon as audit data has been archived Purge archived audit data I the current example Ill. Begin dbms_eate_JOB ( job_name job_type 'plsql_block job_action 'begin sysdate-10 END start_date sysdate, repeat_interval 'freqhourly;interval24 enabled true, comments 'Create an archive timestamp' END; / Create daily purge job begin dbms_audit_eate_purge_JOB( audit_trail_type dbms_audit_DIT_trail_AUD_STD, audit_trail_purge_interval 24 hours audit_trail_purge_name 'Daily_Audit_Purge_Job USE_last_arch_timestamp . Now lets enable audit for certain system privilege and objects. Online inschrijvingen vanaf 20:00 80 0/80 35,00 ma vr, paassportkamp Kuikentje Piep, leeftijdscategorie 14-13, sporthal Temsica.