SQL> create table IOT_MAPPING_TEST (name varchar2(32),
  2                                 no number,
  3                                 constraint PK_IOT_MAPPING_TEST primary key(no)
  4                                 )
  5  organization index
  6  mapping table;

Table created

SQL> 
SQL> select table_name,iot_name,iot_type from user_tables where table_name='IOT_MAPPING_TEST';

TABLE_NAME                     IOT_NAME                       IOT_TYPE
------------------------------ ------------------------------ ------------
IOT_MAPPING_TEST                                              IOT

SQL> select table_name,iot_name,iot_type from user_tables where iot_type='IOT_MAPPING';

TABLE_NAME                     IOT_NAME                       IOT_TYPE
------------------------------ ------------------------------ ------------
SYS_IOT_MAP_56839              IOT_MAPPING_TEST               IOT_MAPPING

SQL> 
SQL> alter table iot_mapping_test shrink space;

Table altered

SQL> alter table SYS_IOT_MAP_56839 shrink space;

alter table SYS_IOT_MAP_56839 shrink space

ORA-28668: cannot reference mapping table of an index-organized table
ITPub博客

Shrink 不支持IOT MAPPING TABLES的测试（转）

最新文章
