Move Oracle database audit-related tables to other tablespaces

Move the Oracle database audit-related tables to other tablespaces:

Because audit-related tables such as AUD $ are stored in the SYSTEM tablespace, it is best to move AUD $ to other tablespaces to protect the SYSTEM tablespace without affecting SYSTEM performance. You can use the following statement to move:

SQL> connect/as sysdba;

SQL> alter table aud $ move tablespace <new tablespace>;

SQL> alter index I _aud1 rebuild online tablespace <new tablespace>;

SQL> alter table audit $ move tablespace <new tablespace>;

SQL> alter index I _audit rebuild online tablespace <new tablespace>;

SQL> alter table audit_actions move tablespace <new tablespace>;

SQL> alter index I _audit_actions rebuild online tablespace <new tablespace>;