ALL_TAB_SUBPARTITIONS

Columns
   ___________________________
 
   PCT_FREE
   TABLE_OWNER
   TABLE_NAME
   PARTITION_NAME
   SUBPARTITION_NAME
   LOGGING
   USER_STATS
   GLOBAL_STATS
   BUFFER_POOL
   LAST_ANALYZED
   SAMPLE_SIZE
   AVG_ROW_LEN
   CHAIN_CNT
   AVG_SPACE
   EMPTY_BLOCKS
   SUBPARTITION_POSITION
   NUM_ROWS
   TABLESPACE_NAME
   FREELISTS
   MAX_EXTENT
   MIN_EXTENT
   NEXT_EXTENT
   INITIAL_EXTENT
   MAX_TRANS
   INI_TRANS
   PCT_USED
   PCT_INCREASE
   BLOCKS
   FREELIST_GROUPS

Related Commands: