DBA_PART_TABLES v11

The DBA_PART_TABLES view provides information about all of the partitioned tables in the database.

NameTypeDescription
ownerTEXTThe owner of the partitioned table.
schema_nameTEXTThe schema in which the table resides.
table_nameTEXTThe name of the table.
partitioning_typeTEXTThe type used to define table partitions.
subpartitioning_typeTEXTThe subpartitioning type used to define table subpartitions.
partition_countBIGINTThe number of partitions in the table.
def_subpartition_countINTEGERThe number of subpartitions in the table.
partitioning_key_countINTEGERThe number of partitioning keys specified.
subpartitioning_key_countINTEGERThe number of subpartitioning keys specified.
statusCHARACTER VARYING(8)Provided for compatibility only. Always VALID.
def_tablespace_nameCHARACTER VARYING(30)Provided for compatibility only. Always NULL.
def_pct_freeNUMERICProvided for compatibility only. Always NULL.
def_pct_usedNUMERICProvided for compatibility only. Always NULL.
def_ini_transNUMERICProvided for compatibility only. Always NULL.
def_max_transNUMERICProvided for compatibility only. Always NULL.
def_initial_extentCHARACTER VARYING(40)Provided for compatibility only. Always NULL.
def_next_extentCHARACTER VARYING(40)Provided for compatibility only. Always NULL.
def_min_extentsCHARACTER VARYING(40)Provided for compatibility only. Always NULL.
def_max_extentsCHARACTER VARYING(40)Provided for compatibility only. Always NULL.
def_pct_increaseCHARACTER VARYING(40)Provided for compatibility only. Always NULL.
def_freelistsNUMERICProvided for compatibility only. Always NULL.
def_freelist_groupsNUMERICProvided for compatibility only. Always NULL.
def_loggingCHARACTER VARYING(7)Provided for compatibility only. Always YES.
def_compressionCHARACTER VARYING(8)Provided for compatibility only. Always NONE.
def_buffer_poolCHARACTER VARYING(7)Provided for compatibility only. Always DEFAULT.
ref_ptn_constraint_nameCHARACTER VARYING(30)Provided for compatibility only. Always NULL.
intervalCHARACTER VARYING(1000)Provided for compatibility only. Always NULL.