How should I manage the size the large audit tables?
Hello,
I have been asked to manage the audit tables (only aud$) for production databases. The size of the audit tables are quite large (>45GB). I cross-checked some answers in the Oracle community, many of the answers involve moving the audit trail tables using procedure DBMS_AUDIT_MGMT. (Doc ID 1328239.1)
But my case has a small difference. The audit tablespace has already been assigned to a different existing tablespace (not SYSTEM tablespace). How can I manage the audit tables in this case? Also, is it safe to truncate, delete, or purge rows from the Audit Trail Table AUD$? If so, how can I proceed?