column HIGH_VALUE format a10 SELECT INDEX_NAME, PARTITION_NAME, STATUS, HIGH_VALUE, TABLESPACE_NAME --'alter index PAC1.'||index_name||' rebuild partition '|| partITION_name||' tablespace PAC_INDICES;' FROM DBA_IND_PARTITIONS WHERE INDEX_NAME IN ( SELECT INDEX_NAME FROM DBA_PART_INDEXES WHERE TABLE_NAME = UPPER('&1') ) ORDER BY PARTITION_NAME DESC /