借助上面的测试，顺便介绍一下如何move IOT MAPPING TABLES。移动IOT MAPPING TABLES的语法是：

ALTER TABLE <TABLE_NAME> MOVE MAPPING TABLE TABLESPACE <TBS_NAME>;

下面做个简单的测试

SQL> select segment_name,segment_type,tablespace_name from user_segments where segment_name like '%MAP%';

SEGMENT_NAME              SEGMENT_TYPE       TABLESPACE_NAME
------------------------- ------------------ ---------------------
SYS_IOT_MAP_56839         TABLE              DATA_01
PK_IOT_MAPPING_TEST       INDEX              DATA_01

SQL> alter table iot_mapping_test move tablespace users;

Table altered

SQL> select segment_name,segment_type,tablespace_name from user_segments where segment_name like '%MAP%';

SEGMENT_NAME                    SEGMENT_TYPE       TABLESPACE_NAME
------------------------------- ------------------ -----------------
SYS_IOT_MAP_56839               TABLE              DATA_01
PK_IOT_MAPPING_TEST             INDEX              USERS

可以看到，常规的move操作只是表索引移了。

SQL> alter table iot_mapping_test move mapping table tablespace users;

Table altered

SQL> select segment_name,segment_type,tablespace_name from user_segments where segment_name like '%MAP%';

SEGMENT_NAME              SEGMENT_TYPE       TABLESPACE_NAME
------------------------- ------------------ ---------------------
SYS_IOT_MAP_56839         TABLE              USERS
PK_IOT_MAPPING_TEST       INDEX              USERS

SQL> 
OK，到这里mapping table被成功的移动了