Moving AUD$ Table To Another Tablespace

Hello,

If your AUD$ table is in SYSTEM tablespace, then it is advised to move the AUD$ table to a dedicated tablespace like SYSAUX.

1- Check AUD$ table location.

select owner,segment_name,TABLESPACE_NAME,SEGMENT_TYPE,SEGMENT_SUBTYPE from dba_segments where segment_name=’AUD$’;

2- Create a new tablespace for AUD$ table

create tablespace auditts datafile ‘+DATA’ size 100M autoextend on next 100M maxsize unlimited;

3- And move AUD$ table (audit trail) to created tablespace.

BEGIN
DBMS_AUDIT_MGMT.set_audit_trail_location( audit_trail_type => DBMS_AUDIT_MGMT.AUDIT_TRAIL_AUD_STD,audit_trail_location_value => ‘AUDITTS’);
END;
/

commit;

4- Now let me check AUD$ table location again.

select owner,segment_name,TABLESPACE_NAME,SEGMENT_TYPE,SEGMENT_SUBTYPE from dba_segments where segment_name=’AUD$’;

Advertisement