Migration of Oracle Audit-related objects

Directory

• Create a table space for auditing
• Online migration
• Query results

In routine database maintenance, it often occurs because the database logon audit function starts, which causes the system table space to be full. In this case, it is generally recommended to migrate aud$ related objects to other tablespaces to avoid the risk of system being exhausted.
The steps are as follows:

Create a table space for auditing

[email protected]> create tablespace audit_data logging datafile ‘/oracle/oradata/kyeupdbfs/audit_data.dbf‘  2  size 20m autoextend off extent management local segment space management auto;Tablespace created.

Online migration

[email protected]> alter table aud$ move tablespace audit_data;Table altered.[email protected]> alter table audit$ move tablespace audit_data;Table altered.[email protected]> alter table audit_actions move tablespace audit_data;Table altered.[email protected]> alter index i_audit rebuild online tablespace audit_data;Index altered.[email protected]> alter index i_audit_actions rebuild online tablespace audit_data;Index altered.

Query results

```
Select Table_name,tablespace_name from dba_tables where table_name like '%aud% ';
Select Index_name,tablespace_name from dba_indexes where table_name like '%aud% ';
Select Table_name,tablespace_name from Dba_tables where tablespace_name= ' audit_data ';
Select Index_name,tablespace_name from dba_indexes where tablespace_name= ' audit_data ';

Migration of Oracle Audit-related objects