ALTER INDEX USER_NAME.INDEX_NAME
REBUILD NOPARALLEL
NOLOGGING
TABLESPACE INDX
STORAGE( INITIAL 131072 NEXT 131072 PCTINCREASE 0)
REBUILD NOPARALLEL
NOLOGGING
TABLESPACE INDX
STORAGE( INITIAL 131072 NEXT 131072 PCTINCREASE 0)
1.drop ,then build
2.rebuild