当使用DBMS_AUDIT_MGMT.SET_AUDIT_TRAIL_LOCATION 更改用于存储审核数据的默认表空间时，会在新表空间中创建AUDSYS.AUD$UNIFIED表的所有新表分区，lob分区和索引分区。 （旧的分区仍保留在原表空间）

如果未在新表空间中创建LOB和INDEX分区，可能是BUG， 需要补丁。 BUG 27576342：DBMS_AUDIT_MGMT.SET_AUDIT_TRAIL_LOCATION不会移动LOB和索引分区

更改默认表空间示例：

col segment_name for a25
col tablespace_name for a20 
select segment_name,ds.tablespace_name from dba_segments ds where owner = 'AUDSYS';
SEGMENT_NAME              TABLESPACE_NAME
------------------------- --------------------
AUD$UNIFIED               SYSAUX
AUD$UNIFIED               SYSAUX
AUD$UNIFIED               SYSAUX
AUD$UNIFIED               SYSAUX
AUD$UNIFIED               SYSAUX
SYS_IL0000018570C00097$$  SYSAUX
SYS_IL0000018570C00031$$  SYSAUX
SYS_IL0000018570C00030$$  SYSAUX
SYS_IL0000018570C00097$$  SYSAUX
SYS_IL0000018570C00031$$  SYSAUX
SYS_IL0000018570C00030$$  SYSAUX
SYS_IL0000018570C00097$$  SYSAUX
SYS_IL0000018570C00031$$  SYSAUX



SYS@ORCLCDB>select table_owner,table_name,tablespace_name,partition_name,partition_position,segment_created,read_only from dba_tab_partitions where table_name like 'AUD%';

TABLE_OWNE TABLE_NAME           TABLESPACE_NAME      PARTITION_NAME       PARTITION_POSITION SEGMENT_ READ_ONL
---------- -------------------- -------------------- -------------------- ------------------ -------- --------
AUDSYS     AUD$UNIFIED          SYSAUX               AUD_UNIFIED_P0                        1 NO       NO
AUDSYS     AUD$UNIFIED          SYSAUX               SYS_P181                              2 YES      NO
AUDSYS     AUD$UNIFIED          SYSAUX               SYS_P771                              3 YES      NO
AUDSYS     AUD$UNIFIED          SYSAUX               SYS_P1420                             4 YES      NO
AUDSYS     AUD$UNIFIED          SYSAUX               SYS_P1920                             5 YES      NO
AUDSYS     AUD$UNIFIED          SYSAUX               SYS_P2560                             6 YES      NO

SQL> create tablespace AUDITTS datafile '<PATH>/auditts.dbf' size 100M autoextend on;

Tablespace created.
#更改审计默认表空间