DBA_TAB_SUBPARTITIONS v16

The DBA_TAB_SUBPARTITIONS view provides information about all of the subpartitions that reside in the database.

NameTypeDescription
table_ownerTEXTOwner of the table in which the subpartition resides.
schema_nameTEXTName of the schema in which the table resides.
table_nameTEXTName of the table.
partition_nameTEXTName of the partition.
subpartition_nameTEXTName of the subpartition.
high_valueTEXTHigh-subpartitioning value specified in the CREATE TABLE statement.
high_value_lengthINTEGERLength of high-partitioning value.
subpartition_positionINTEGEROrdinal position of this subpartition.
tablespace_nameTEXTName of the tablespace in which the subpartition resides. If the tablespace name isn't specified, the default tablespace ia PG_DEFAULT.
pct_freeNUMERICIncluded only for compatibility. Always 0.
pct_usedNUMERICIncluded only for compatibility. Always 0.
ini_transNUMERICIncluded only for compatibility. Always 0.
max_transNUMERICIncluded only for compatibility. Always 0.
initial_extentNUMERICIncluded only for compatibility. Always NULL.
next_extentNUMERICIncluded only for compatibility. Always NULL.
min_extentNUMERICIncluded only for compatibility. Always 0.
max_extentNUMERICIncluded only for compatibility. Always 0.
pct_increaseNUMERICIncluded only for compatibility. Always 0.
freelistsNUMERICIncluded only for compatibility. Always NULL.
freelist_groupsNUMERICIncluded only for compatibility. Always NULL.
loggingCHARACTER VARYING(7)Included only for compatibility. Always YES.
compressionCHARACTER VARYING(8)Included only for compatibility. Always NONE.
num_rowsNUMERICSame as pg_class.reltuples.
blocksINTEGERSame as pg_class.relpages.
empty_blocksNUMERICIncluded only for compatibility. Always NULL.
avg_spaceNUMERICIncluded only for compatibility. Always NULL.
chain_cntNUMERICIncluded only for compatibility. Always NULL.
avg_row_lenNUMERICIncluded only for compatibility. Always NULL.
sample_sizeNUMERICIncluded only for compatibility. Always NULL.
last_analyzedTIMESTAMP WITHOUT TIME ZONEIncluded only for compatibility. Always NULL.
buffer_poolCHARACTER VARYING(7)Included only for compatibility. Always NULL.
global_statsCHARACTER VARYING(3)Included only for compatibility. Always YES.
user_statsCHARACTER VARYING(3)Included only for compatibility. Always NO.
backing_tableREGCLASSName of the subpartition backing table.