The DBA_TAB_SUBPARTITIONS view provides the information about all subpartitions that locate in the database.
| Parameter | Type | Description |
|---|---|---|
| table_owner | TEXT | The owner of the table where a subpartition is located. |
| schema_name | TEXT | The name of the schema where the table is located. |
| table_name | TEXT | The name of the table. |
| partition_name | TEXT | The name of the partition. |
| subpartition_name | TEXT | The name of the subpartition. |
| high_value | TEXT | The high subpartitioning value specified in the CREATE TABLE statement. |
| high_value_length | INTEGER | The length of the high subpartitioning value. |
| subpartition_position | INTEGER | The ordinal position of this subpartition. For example, a value of 1 indicates the first subpartition and a value of 2 indicates the second subpartition. All positions of subpartitions follow the same rule. |
| tablespace_name | TEXT | The name of the tablespace where the subpartition is located. |
| pct_free | NUMERIC | This parameter is supported for compatibility only. The value is 0. |
| pct_used | NUMERIC | This parameter is supported for compatibility only. The value is 0. |
| ini_trans | NUMERIC | This parameter is supported for compatibility only. The value is 0. |
| max_trans | NUMERIC | This parameter is supported for compatibility only. The value is 0. |
| initial_extent | NUMERIC | This parameter is supported for compatibility only. The value is NULL. |
| next_extent | NUMERIC | This parameter is supported for compatibility only. The value is NULL. |
| min_extent | NUMERIC | This parameter is supported for compatibility only. The value is 0. |
| max_extent | NUMERIC | This parameter is supported for compatibility only. The value is 0. |
| pct_increase | NUMERIC | This parameter is supported for compatibility only. The value is 0. |
| freelists | NUMERIC | This parameter is supported for compatibility only. The value is NULL. |
| freelist_groups | NUMERIC | This parameter is supported for compatibility only. The value is NULL. |
| logging | CHARACTER VARYING(7) | This parameter is supported for compatibility only. The value is YES. |
| compression | CHARACTER VARYING(8) | This parameter is supported for compatibility only. The value is NONE. |
| num_rows | NUMERIC | The same as pg_class.reltuples. |
| blocks | INTEGER | The same as pg_class.relpages. |
| empty_blocks | NUMERIC | This parameter is supported for compatibility only. The value is NULL. |
| avg_space | NUMERIC | This parameter is supported for compatibility only. The value is NULL. |
| chain_cnt | NUMERIC | This parameter is supported for compatibility only. The value is NULL. |
| avg_row_len | NUMERIC | This parameter is supported for compatibility only. The value is NULL. |
| sample_size | NUMERIC | This parameter is supported for compatibility only. The value is NULL. |
| last_analyzed | TIMESTAMP WITHOUT TIME ZONE | This parameter is supported for compatibility only. The value is NULL. |
| buffer_pool | CHARACTER VARYING(7) | This parameter is supported for compatibility only. The value is NULL. |
| global_stats | CHARACTER VARYING(3) | This parameter is supported for compatibility only. The value is YES. |
| user_stats | CHARACTER VARYING(3) | This parameter is supported for compatibility only. The value is NO. |
| backing_table | REGCLASS | The name of the subpartition backup table. |