Oracle migration and audit-related table and index tablespace

 

BecauseAUD $Audit-related tables such as tables are stored inSystemTherefore, to avoid affecting system performanceSystemTablespace.AUD $Move to another tablespace. You can use the following statement to move:

 

[Oracle @ cent4 ~] $ Sqlplus/As sysdbasql> alter table aud $ move tablespace users; Table altered. SQL> alter index I _aud1 rebuild online tablespace users; index altered. SQL> ALTER TABLE audit $ move tablespace users; Table altered. SQL> alter index I _audit rebuild online tablespace users; index altered. SQL> ALTER TABLE audit_actions move tablespace users; Table altered. SQL> alter index I _audit_actions rebuild online tablespace users; index altered.

Mainly to migrateAUD $, I _aud1.