Home Oracle Commands Oracle Data Dictionary
v$ Performance views

USER_TAB_PARTITIONS

Data Dictionary View

Columns
   ___________________________
 
   TABLE_NAME
      --
   COMPOSITE
      --
   PARTITION_NAME
      --
   SUBPARTITION_COUNT
      --
   HIGH_VALUE
      --
   HIGH_VALUE_LENGTH
      --
   PARTITION_POSITION
      --
   TABLESPACE_NAME
      --
   PCT_FREE
      --
   PCT_USED
      --
   INI_TRANS
      --
   MAX_TRANS
      --
   INITIAL_EXTENT
      --
   NEXT_EXTENT
      --
   MIN_EXTENT
      --
   MAX_EXTENT
      --
   PCT_INCREASE
      --
   FREELISTS
      --
   FREELIST_GROUPS
      --
   LOGGING
      --
   COMPRESSION
      --
   NUM_ROWS
      --
   BLOCKS
      --
   EMPTY_BLOCKS
      --
   AVG_SPACE
      --
   CHAIN_CNT
      --
   AVG_ROW_LEN
      --
   SAMPLE_SIZE
      --
   LAST_ANALYZED
      --
   BUFFER_POOL
      --
   GLOBAL_STATS
      --
   USER_STATS
      --

Related:

 DBA_ALL_TABLES         ALL_ALL_TABLES        USER_ALL_TABLES
 DBA_PARTIAL_DROP_TABS  ALL_PARTIAL_DROP_TABS USER_PARTIAL_DROP_TABS
 DBA_PART_TABLES        ALL_PART_TABLES       USER_PART_TABLES 
 DBA_TABLES             ALL_TABLES            USER_TABLES          TAB 
 DBA_TABLESPACES                              USER_TABLESPACES 
 DBA_TAB_COLUMNS        ALL_TAB_COLUMNS       USER_TAB_COLUMNS 
 DBA_TAB_COLS           ALL_TAB_COLS          USER_TAB_COLS 
 DBA_TAB_COMMENTS       ALL_TAB_COMMENTS      USER_TAB_COMMENTS 
 DBA_TAB_HISTOGRAMS     ALL_TAB_HISTOGRAMS    USER_TAB_HISTOGRAMS 
 DBA_TAB_MODIFICATIONS  ALL_TAB_MODIFICATIONS USER_TAB_MODIFICATIONS 
 DBA_TAB_PARTITIONS     ALL_TAB_PARTITIONS    USER_TAB_PARTITIONS 



Simon Sheppard
SS64.com