Home Oracle Commands Oracle Data Dictionary
v$ Performance views

USER_PART_TABLES

Data Dictionary View

Columns
   ___________________________
 
   TABLE_NAME

   PARTITIONING_TYPE

   SUBPARTITIONING_TYPE

   PARTITION_COUNT

   DEF_SUBPARTITION_COUNT

   PARTITIONING_KEY_COUNT

   SUBPARTITIONING_KEY_COUNT

   DEF_TABLESPACE_NAME

   DEF_PCT_FREE

   DEF_PCT_USED

   DEF_INI_TRANS

   DEF_MAX_TRANS

   DEF_INITIAL_EXTENT

   DEF_NEXT_EXTENT

   DEF_MIN_EXTENTS

   DEF_MAX_EXTENTS

   DEF_PCT_INCREASE

   DEF_FREELISTS

   DEF_FREELIST_GROUPS

   DEF_LOGGING

   DEF_COMPRESSION

   DEF_BUFFER_POOL

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