If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

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?

We would like to seek your advice on moving AUD$ table from SYSTEM tablespace to another tablespace(AUDIT_DATA). This has to be tested in dev environment and we are planning to implement the same on prod.

1) We would like to know to know how to perform this AUD$ table re-location (step by step).
2) Currently audit is not enabled, so while enabling it will create any kind of performance issues in the database?
3) Auditing is going to enable for a particular set of tables owned by particular user.
4) Does any particular standard for creating tablespace for this purpose and how much size needs to be allocated?
5) Is this a better option to use “DBMS_AUDIT_MGMT.SET_AUDIT_TRAIL_LOCATION” procedure to move AUD$ table?

Current version of the database:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
PL/SQL Release 11.1.0.7.0 - Production
CORE 11.1.0.7.0 Production
TNS for Linux: Version 11.1.0.7.0 - Production
NLSRTL Version 11.1.0.7.0 – Production

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

Here is some code that will create a partitioned table and migrate any data older than a day to the partitioned table. You need the RAWTOHEX("XID") function of RAW columns. You can change it to suit your needs.