Inquiry on Re-locating AUD$ table from system to another tablespace
We would like to seek your advice on moving AUD$ table from SYSTEM tablespace to another tablespace(AUDIT_DATA). This going to be tested in Dev env.
1) Currently audit is not enabled, so while enabling it will create any kind of performance issues in the database?
2) Auditing is going to enable for a particular set of tables owned by particular user.
3) Does any particular standard for creating tablespace for this purpose and how much size needs to be allocated?
4) Is this a better option to use “DBMS_AUDIT_MGMT.SET_AUDIT_TRAIL_LOCATION” procedure to move AUD$ table?
audit_trail_type => DBMS_AUDIT_MGMT.AUDIT_TRAIL_AUD_STD,
audit_trail_location_value => AUDIT_DATA);