— par_ind_dets.sql
— mdw 13/7/01
— details of partition index partitions
col index_owner form a8 wrap head ownr
col index_name  form a15 word wrap
col tablespace_name  form a8 word wrap head ts_name
col partition_name  form a10 word wrap head part_name
col leaf_blocks form 999,999 head lf_blks
col high_value form a12 wrap
spool par_dets.lst
select index_owner
,index_name
,partition_name
,tablespace_name
,leaf_blocks
,substr(status,1,5) sts
,to_char(last_analyzed,’DD-MON-YY’) last_anal
,high_value
from dba_ind_partitions dip
where index_name like upper(nvl(‘&pind_name’,’eric’))||’%’
order by index_name,index_owner,partition_position
/
clear col
spool off