Default tablespace for unified auditing

User_KYWTC

Hello Team,

I am enabling unified auditing and I want all my audit records to be placed in a dedicated tablespace rather  than the default tablespace sysaux.

SQL> BEGIN
        dbms_audit_mgmt.set_audit_trail_location(
        audit_trail_type => dbms_audit_mgmt.audit_trail_unified,
        audit_trail_location_value => '<NEW_TABLESPACE_CREATED_TO_STORE_UNIFIED_RECORDS>');

         /

After assigning dedicated tablespace, i could  see all my audit records are still stored in sysaux and not in the dedicated tablespace.
Could you please help me to understand for the reason behind this.

SQL> select SEGMENT_NAME,SEGMENT_SUBTYPE,SEGMENT_TYPE,BYTES/1024/1024,TABLESPACE_NAME  from dba_segments where OWNER = 'AUDSYS' order by 1;

SEGMENT_NAME       SEGMENT_SU SEGMENT_TYPE     BYTES/1024/1024 TABLESPACE_NAME

--------------------------------------------- ---------- ------------------ --------------- ------------------------------

AUD$UNIFIED       ASSM TABLE PARTITION       .1875 SYSAUX

AUD$UNIFIED       ASSM TABLE PARTITION       .0625 SYSAUX

SYS_IL0000018570C00030$$       ASSM INDEX PARTITION       .0625 SYSAUX

SYS_IL0000018570C00030$$       ASSM INDEX PARTITION       .0625 SYSAUX

SYS_IL0000018570C00031$$       ASSM INDEX PARTITION       .0625 SYSAUX

SYS_IL0000018570C00031$$       ASSM INDEX PARTITION       .0625 SYSAUX

SYS_IL0000018570C00097$$       ASSM INDEX PARTITION       .0625 SYSAUX

SYS_IL0000018570C00097$$       ASSM INDEX PARTITION       .0625 SYSAUX

SYS_LOB0000018570C00030$$       SECUREFILE LOB PARTITION        .125 SYSAUX

SYS_LOB0000018570C00030$$       SECUREFILE LOB PARTITION        .125 SYSAUX

SYS_LOB0000018570C00031$$       SECUREFILE LOB PARTITION        .125 SYSAUX

SYS_LOB0000018570C00031$$       SECUREFILE LOB PARTITION        .125 SYSAUX

SYS_LOB0000018570C00097$$       SECUREFILE LOB PARTITION        .125 SYSAUX

SYS_LOB0000018570C00097$$       SECUREFILE LOB PARTITION        .125 SYSAUX

14 rows selected.

Note : Instead of assigning dedicated tablespace using  dbms_audit_mgmt, what will happen if i just change the default tablespace of audsys user to the dedicated one i want.

alter user audsys default tablespace <<TBS_NAME>>

Thanks,

Bala

JimFx

Audit data stays in the current tablespace until a new partition is created. The new partition will then be in the tablespace specified with set_audit_trail_location. The default is one month for the partition interval.

Jim

User_KYWTC

Thanks Jim. It was useful.