Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

dbms_audit_mgmt -- Oracle 19c version 19.14.0.0

Francois van ZylFeb 3 2022 — edited Feb 3 2022

I have a need to periodically archive the audit DB table (AUD$). I have moved the table to it's own dedicated table space, created required policies and it is working fine creating logs as expected. I understand the init_cleanup proc to move the aud$ table to the sysaux tablespace in anticipation of the purge, the setting of the timestamp to limit what is purged and then cleaning the audit trail using DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL which, according to all I have read, will remove records from the table without the need for a manual delete. My question is, before purging the data, the records in the table need to be archived to an OS file. Do I have to use expdp to achieve this or is functionality for that in dbms_audit_mgmt (ie generate the file name and export the data to new file).

Comments
Post Details
Added on Feb 3 2022
1 comment
615 views