move 表索引失效

SQL> select INDEX_NAME,status from user_indexes;


INDEX_NAME       STATUS
------------------------------ --------
SYS_IL0000324358C00006$$       VALID
TEST1_IDX1       VALID


SQL> alter table test1 move;


Table altered.


SQL> select INDEX_NAME,status from user_indexes;


INDEX_NAME       STATUS
------------------------------ --------
SYS_IL0000324358C00006$$       VALID
TEST1_IDX1       UNUSABLE
posted @ 2014-06-12 16:34  czcb  阅读(144)  评论(0编辑  收藏  举报