【Oracle】-【move】【索引】无数据的主键索引VALID还是UNUSABLE

最新推荐文章于 2023-12-19 16:41:05 发布

bisal(Chen Liu)

最新推荐文章于 2023-12-19 16:41:05 发布

阅读量2.4k

点赞数

分类专栏：技术之我见

本文链接：https://blog.csdn.net/bisal/article/details/9181039

版权

技术之我见专栏收录该内容

291 篇文章 5 订阅

订阅专栏

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