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

SQL>  ALTER INDEX CTXSYS.SYS_IOT_TOP_68652 REBUILD TABLESPACE SYSAUX;

 ALTER INDEX CTXSYS.SYS_IOT_TOP_68652 REBUILD TABLESPACE SYSAUX

*

ERROR at line 1:

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

SQL> SELECT INDEX_NAME, INDEX_TYPE, TABLE_NAME,TABLESPACE_NAME FROM DBA_INDEXES where INDEX_NAME='SYS_IOT_TOP_68652';

 
INDEX_NAME                     INDEX_TYPE                  TABLE_NAME                     TABLESPACE_NAME
------------------------------ --------------------------- ------------------------------ ------------------------------
SYS_IOT_TOP_68652              IOT - TOP                   DR$WAITING                     FMS_IDX_TS

Here table name is  DR$WAITING.  If we move the table automatically indexes also will get moved to the other tablespace

                

SQL>  alter table ctxsys.dr$WAITING      move tablespace sysaux;

                         Table altered.

SQL> select owner,index_name,index_type,table_owner,table_name,table_type,status                            from   dba_indexes where table_name='DR$WAITING';

 

OWNER                          INDEX_NAME                     INDEX_TYPE                  TABLE_OWNER                    TABLE_NAME                     TABLE_TYPE  STATUS
------------------------------ ------------------------------ --------------------------- ------------------------------ ------------------------------ ----------- --------
CTXSYS                         SYS_IOT_TOP_68652              IOT - TOP                   CTXSYS                         DR$WAITING                     TABLE       VALID