ALL_PART_TABLES

Data Dictionary View

Columns
   ___________________________

   OWNER
   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_PART_TABLES        ALL_PART_TABLES       USER_PART_TABLES 
 DBA_TABLES             ALL_TABLES            USER_TABLES          TAB 
 DBA_TAB_PARTITIONS     ALL_TAB_PARTITIONS    USER_TAB_PARTITIONS 


© Copyright SS64.com 1999-2014
Some rights reserved