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 ------------------------------------------------------------ ----------------
SYS_C006251 VALID
表没有数据,则move后主键索引仍VALID,但普通INDEX是UNUSABLE