当move表时索引会失效，需重建索引。索引的移动操做为rebuild

/*+ INDEX(b idx_tb_fat_user_01) parallel(a,10) */

alter index idx_name rebuild;

alter index idx_name rebuild tablespace dpe parallel (degree 5);;

alter index idx_name rebulid partition par_name parallel (degree 10);

alter index idx_serv_number noparallel;

ALTER INDEX LOCAL_ALARMTEXTDATA REBUILD SUBPARTITION ALARMTEXTDATA_050910_ATD01 TABLESPACE users PARALLEL (DEGREE 2);

create index idx_serv_number on yl.tb_fat_tsm_ac_user_income_m(serv_number)
tablespace TBS_MK_IDX
LOCAL ( 
  PARTITION USER_200808
    LOGGING
    NOCOMPRESS
    TABLESPACE TBS_MK_IDX, 
  PARTITION USER_200809
    LOGGING
    NOCOMPRESS
    TABLESPACE TBS_MK_IDX, 
  PARTITION USER_200810
    LOGGING
    NOCOMPRESS
    TABLESPACE TBS_MK_IDX, 
  PARTITION USER_200811
    LOGGING
    NOCOMPRESS
    TABLESPACE TBS_MK_IDX, 
  PARTITION USER_200812
    LOGGING
    NOCOMPRESS
    TABLESPACE TBS_MK_IDX, 
  PARTITION USER_200901
    LOGGING
    NOCOMPRESS
    TABLESPACE TBS_MK_IDX,
  PARTITION USER_200902
    LOGGING
    NOCOMPRESS
    TABLESPACE TBS_MK_IDX
)
parallel (degree 10)
;

create unique INDEX HWDIC.IDX_TB_DIC_CALLOUT_EMPLOYEE_01 ON HWDIC.TB_DIC_CALLOUT_EMPLOYEE
(EMPLOYEE_ID)
LOGGING
TABLESPACE TBS_D1
NOPARALLEL
;