Some Useful SQLs for Partitioning

-- for local partitioned Index
SELECT INDEX_NAME,LOCALITY,PARTITIONING_TYPE,PARTITION_COUNT,SUBPARTITIONING_TYPE,DEF_SUBPARTITION_COUNT,DEF_TABLESPACE_NAME,
INTERVAL FROM  ALL_PART_INDEXES
WHERE  TABLE_NAME='table_name'  ;