SQL> desc t_PRIMARY;
Name Null? Type
----------------------------------------- -------- ----------------------------
X NOT NULL NUMBER(38)
SQL> insert into t_primary values(1);
1 row created.
SQL> select * from t_primary;
X
----------
1
SQL> select index_name, status from user_indexes where table_name='T_PRIMARY';
INDEX_NAME STATUS
------------------------------------------------------------ ----------------
SYS_C006251 VALID
SQL> alter table t_primary move;
Table altered.
SQL> select index_name, status from user_indexes where table_name='T_PRIMARY';
INDEX_NAME STATUS
------------------------------------------------------------ ----------------
SYS_C006251 UNUSABLE
SQL> alter index SYS_C006251 rebuild;
Index altered.
SQL> select index_name, status from user_indexes where table_name='T_PRIMARY';
INDEX_NAME STATUS
------------------------------------------------------------ ----------------
Name Null? Type
----------------------------------------- -------- ----------------------------
X NOT NULL NUMBER(38)
SQL> insert into t_primary values(1);
1 row created.
SQL> select * from t_primary;
X
----------
1
SQL> select index_name, status from user_indexes where table_name='T_PRIMARY';
INDEX_NAME STATUS
------------------------------------------------------------ ----------------
SYS_C006251 VALID
SQL> alter table t_primary move;
Table altered.
SQL> select index_name, status from user_indexes where table_name='T_PRIMARY';
INDEX_NAME STATUS
------------------------------------------------------------ ----------------
SYS_C006251 UNUSABLE
SQL> alter index SYS_C006251 rebuild;
Index altered.
SQL> select index_name, status from user_indexes where table_name='T_PRIMARY';
INDEX_NAME STATUS
------------------------------------------------------------ ----------------
SYS_C006251 VALID
表没有数据，则move后主键索引仍VALID，但普通INDEX是UNUSABLE
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/7192724/viewspace-767158/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
