添加主键语法的差异，导致表move后索引不能rebuild

SQL> create table  test_pk
  2  (ID    NUMBER(19) not null,
  3   NAME   VARCHAR2(255 CHAR));

Table created

 

SQL>  create table  test_pk2
  2  (ID    NUMBER(19) not null,
  3   NAME   VARCHAR2(255 CHAR));

Table created

SQL>

SQL> alter table test_pk  add primary key (ID);

Table altered

-- 这种方式添的主键，表move后，该索引不能rebuild

 

 

SQL> alter table test_pk2  add constraint TESTPK_ID primary key (ID);

Table altered

SQL>

 

SQL> select T.table_name,T.index_name , T.status
  2   from USER_INDEXES t
  3   where t.table_name in ( 'TEST_PK','TEST_PK2' );

 

TABLE_NAME                     INDEX_NAME                     STATUS
------------------------------ ------------------------------ --------
TEST_PK                        SYS_C00405492                  VALID
TEST_PK2                       TESTPK_ID                          VALID