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
原文地址:https://www.cnblogs.com/hzcya1995/p/13352273.html