USER_PART_TABLES v16

The USER_PART_TABLES view provides information about all of the partitioned tables in the database that are owned by the current user.

NameTypeDescription
schema_nameTEXTName of the schema in which the table resides.
table_nameTEXTName of the table.
partitioning_typeTEXTPartitioning type used to define table partitions.
subpartitioning_typeTEXTSubpartitioning type used to define table subpartitions.
partition_countBIGINTNumber of partitions in the table.
def_subpartition_countINTEGERNumber of subpartitions in the table.
partitioning_key_countINTEGERNumber of partitioning keys specified.
subpartitioning_key_countINTEGERNumber of subpartitioning keys specified.
statusCHARACTER VARYING(8)Provided only for compatibility. Always VALID.
def_tablespace_nameCHARACTER VARYING(30)Provided only for compatibility. Always NULL.
def_pct_freeNUMERICProvided only for compatibility. Always NULL.
def_pct_usedNUMERICProvided only for compatibility. Always NULL.
def_ini_transNUMERICProvided only for compatibility. Always NULL.
def_max_transNUMERICProvided only for compatibility. Always NULL.
def_initial_extentCHARACTER VARYING(40)Provided only for compatibility. Always NULL.
def_min_extentsCHARACTER VARYING(40)Provided only for compatibility. Always NULL.
def_max_extentsCHARACTER VARYING(40)Provided only for compatibility. Always NULL.
def_pct_increaseCHARACTER VARYING(40)Provided only for compatibility. Always NULL.
def_freelistsNUMERICProvided only for compatibility. Always NULL.
def_freelist_groupsNUMERICProvided only for compatibility. Always NULL.
def_loggingCHARACTER VARYING(7)Provided only for compatibility. Always YES.
def_compressionCHARACTER VARYING(8)Provided only for compatibility. Always NONE.
def_buffer_poolCHARACTER VARYING(7)Provided only for compatibility. Always DEFAULT.
ref_ptn_constraint_nameCHARACTER VARYING(30)Provided only for compatibility. Always NULL.
intervalCHARACTER VARYING(1000)Provided only for compatibility. Always NULL.