ALL_TAB_PARTITIONS v13

The following table lists the information available in the ALL_TAB_PARTITIONS view:

ColumnTypeDescription
table_ownernameThe owner of the table.
schema_namenameThe schema in which the table resides.
table_namenameThe name of the table.
compositetextYES if the table is subpartitioned; NO if it is not subpartitioned.
partition_namenameThe name of the partition.
subpartition_countbigintThe number of subpartitions for this partition.
high_valuetextThe high partitioning value specified in the CREATE TABLE statement.
high_value_lengthintegerThe length of high partitioning value.
partition_positionintegerThe ordinal position of this partition.
tablespace_namenameThe tablespace in which this partition resides.
pct_freenumericThis column will always be 0.
pct_usednumericThis column will always be 0.
ini_transnumericThis column will always be 0.
max_transnumericThis column will always be 0.
initial_extentnumericThis column will always be NULL.
next_extentnumericThis column will always be NULL.
min_extentnumericThis column will always be 0.
max_extentnumericThis column will always be 0.
pct_increasenumericThis column will always be 0.
freelistsnumericThis column will always be NULL.
freelist_groupsnumericThis column will always be NULL.
loggingcharacter varying(7)This column will always be YES.
compressioncharacter varying(8)This column will always be NONE.
num_rowsnumericThe approx. number of rows in this partition.
blocksintegerThe approx. number of blocks in this partition.
empty_blocksnumericThis column will always be NULL.
avg_spacenumericThis column will always be NULL.
chain_cntnumericThis column will always be NULL.
avg_row_lennumericThis column will always be NULL.
sample_sizenumericThis column will always be NULL.
last_analyzedtimestamp without time zoneThis column will always be NULL.
buffer_poolcharacter varying(7)This column will always be NULL.
global_statscharacter varying(3)This column will always be YES.
user_statscharacter varying(3)This column will always be NO.
backing_tableregclassOID of the backing table for this partition.