ORA-28650:Primary index on an IOT cannot be rebuid

今天在EBS上rebuild 索引的时候，发现了一个错误，信息如下：

 

SQL> ALTER INDEX APPLSYS.SYS_IOT_TOP_29343 REBUILD ONLINE NOLOGGING;
ALTER INDEX APPLSYS.SYS_IOT_TOP_29343 REBUILD ONLINE NOLOGGING
*
ERROR at line 1:
ORA-28650: Primary index on an IOT cannot be rebuilt

SQL> ALTER INDEX APPLSYS.SYS_IOT_TOP_29343 LOGGING;
ALTER INDEX APPLSYS.SYS_IOT_TOP_29343 LOGGING
*
ERROR at line 1:
ORA-25176: storage specification not permitted for primary key

 

$ oerr ORA 28650
28650, 00000, "Primary index on an IOT cannot be rebuilt"
// *Cause:  An attempt is made to issue alter index rebuild on IOT-TOP
// *Action: Use Alter table MOVE to reorganize the table(IOT)

 

根据提示找到了解决方法：

1:SQL> alter table AQ$_WF_NOTIFICATION_IN_I move tablespace '新的表空间';
2:SQL> alter table AQ$_WF_NOTIFICATION_IN_I move tablespace '原来的表空间';