分区:
Select 'ALTER INDEX '|| index_name ||' rebuild partition ' || PARTITION_NAME || ' TABLESPACE ' || tablespace_name ||';' from USER_IND_PARTITIONS
子分区:
Select 'ALTER INDEX ' || index_name || ' rebuild subpartition ' ||
SUBPARTITION_NAME || ' TABLESPACE ' || tablespace_name || ' online;'
from user_ind_subpartitions