Moving audit data to another tablespace
Hello,
By default, Oracle audit data (AUDIT_TRAIL_UNIFIED stored in the AUDSYS.AUD$UNIFIED table) is stored in the SYSAUX tablespace. According to the documentation, it is possible to specify another tablespace for storing this information using the SET_AUDIT_TRAIL_LOCATION command from the DBMS_AUDIT_MGMT package. However, based on my tests, this command must be run at a specific time. If this function is run later, it has no effect (the data is not moved).Is there a specific procedure for performing this move once auditing is enabled?