DBA Hub

📋Steps in this guide1/1

How To Move AUD$ Table To Another Tablespace Using DBMS_AUDIT_MGMT

If your AUD$ table is in SYTEM tablespace, Then it is advised to move the AUD$ to a dedicated tablespace. Follow the steps to move AUD$. select

oracle configurationintermediate
by OracleDba
21 views
1

Overview

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
select owner,segment_name,segment_type,tablespace_name,bytes/1024/1024 from dba_segments where segment_name='AUD$';

OWNER SEGMENT_NAME SEGMENT_TYPE TABLESPACE_NAME BYTES/1024/1024
------- ------------- ------------------ ------------------------------ ---------------
SYS AUD$ TABLE SYSTEM 16

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;
/

PL/SQL procedure successfully completed.

select owner,segment_name,segment_type,tablespace_name,bytes/1024/1024 from dba_segments where segment_name='AUD$';

OWNER SEGMENT_NAME SEGMENT_TYPE TABLESPACE_NAME BYTES/1024/1024
------- ------------- ------------------ ------------------------------ ---------------
SYS AUD$ TABLE AUDIT_DATA 16

Comments (0)

Please to add comments

No comments yet. Be the first to comment!