What happens to audit trail records while moving the database audit trail?
I am using the DBMS_AUDIT_MGMT.SET_AUDIT_TRAIL_LOCATION procedure to move the database audit trail tables, SYS.AUD$ and SYS.FGA_log$, but I do not see any mention in Oracle's documentation about what happens to audit trail records being generated during the move.
Database version:
SQL > SELECT * FROM v$version; BANNER -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production PL/SQL Release 11.2.0.4.0 - Production CORE 11.2.0.4.0 Production TNS for Solaris: Version 11.2.0.4.0 - Production NLSRTL Version 11.2.0.4.0 - Production
Audit trail size:
SQL > SELECT segment_name, bytes/1024/1024 size_in_megabytes FROM dba_segments WHERE segment_name IN ('AUD$', 'FGA_LOG$');
SEGMENT_NAME SIZE_IN_MEGABYTES
--------------- -----------------
AUD$ 12074
FGA_LOG$ .0625
1