I need to use DBMS_AUDIT_MGMT to manage DB auditing on one of the databases. The requirement is to store one year's worth of data to another table (other than SYS.AUD$). I realize the package can be used to move SYS.AUD$ table outside of SYSTEM tablespace and define purging/archiving durations on that table. I am not very clear on archiving though. Can this package also be used to archive data from SYS.AUD$ periodically to another table before the purge kicks off on AUD$ or do I have to make a tiny custom script for that.
Also, the DB doesn't need to be in restricted mode in this situation, correct?