分类: Oracle
2010-09-29 21:25:39
Today,when I rebuild index table,but can not executed.There give a message about this:
SQL> alter index "SYSMAN"."MGMT_METRICS_RAW_PK" REBUILD NOLOGGING;
alter index "SYSMAN"."MGMT_METRICS_RAW_PK" REBUILD NOLOGGING
*
ERROR at line 1:
orA-28650: Primary index on an IOT cannot be rebuilt
find error message online
$ 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)
经过上面的分析得出:tab_base 表是索引组织表(index on an IOT)所以altert index "SYSMAN"."MGMT_METRICS_RAW_PK" REBUILD NOLOGGING;,
不能执行.
解决方法:
一:SQL> alter table tab_base move tablespace 'new table';
二:SQL> alter table tab_base move tablespace 'old table'
That all,the problem was resolved .