-
Inquiry on Re-locating AUD$ table from system to another tablespace
Hi
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?
BEGIN
DBMS_AUDIT_MGMT.SET_AUDIT_TRAIL_LOCATION(
audit_trail_type => DBMS_AUDIT_MGMT.AUDIT_TRAIL_AUD_STD,
audit_trail_location_value => AUDIT_DATA);
END;
Please advice
Thanks/Gopu
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|