The DBA_PART_TABLES view provides the information about all partitioned tables in the database.
| Parameter | Type | Description |
|---|---|---|
| owner | TEXT | The owner of a partitioned table. |
| schema_name | TEXT | The schema to which the table belongs. |
| table_name | TEXT | The name of the table. |
| partitioning_type | TEXT | The partition type used to define table partitions. |
| subpartitioning_type | TEXT | The subpartition type used to define table subpartitions. |
| partition_count | BIGINT | The number of partitions in the table. |
| def_subpartition_count | INTEGER | The number of subpartitions in the table. |
| partitioning_key_count | INTEGER | The number of specified partition keys. |
| subpartitioning_key_count | INTEGER | The number of specified subpartition keys. |
| status | CHARACTER VARYING(8) | This parameter is supported for compatibility only. The value is VALID. |
| def_tablespace_name | CHARACTER VARYING(30) | This parameter is supported for compatibility only. The value is NULL. |
| def_pct_free | NUMERIC | This parameter is supported for compatibility only. The value is NULL. |
| def_pct_used | NUMERIC | This parameter is supported for compatibility only. The value is NULL. |
| def_ini_trans | NUMERIC | This parameter is supported for compatibility only. The value is NULL. |
| def_max_trans | NUMERIC | This parameter is supported for compatibility only. The value is NULL. |
| def_initial_extent | CHARACTER VARYING(40) | This parameter is supported for compatibility only. The value is NULL. |
| def_next_extent | CHARACTER VARYING(40) | This parameter is supported for compatibility only. The value is NULL. |
| def_min_extents | CHARACTER VARYING(40) | This parameter is supported for compatibility only. The value is NULL. |
| def_max_extents | CHARACTER VARYING(40) | This parameter is supported for compatibility only. The value is NULL. |
| def_pct_increase | CHARACTER VARYING(40) | This parameter is supported for compatibility only. The value is NULL. |
| def_freelists | NUMERIC | This parameter is supported for compatibility only. The value is NULL. |
| def_freelist_groups | NUMERIC | This parameter is supported for compatibility only. The value is NULL. |
| def_logging | CHARACTER VARYING(7) | This parameter is supported for compatibility only. The value is YES. |
| def_compression | CHARACTER VARYING(8) | This parameter is supported for compatibility only. The value is NONE. |
| def_buffer_pool | CHARACTER VARYING(7) | This parameter is supported for compatibility only. The value is DEFAULT. |
| ref_ptn_constraint_name | CHARACTER VARYING(30) | This parameter is supported for compatibility only. The value is NULL. |
| interval | CHARACTER VARYING(1000) | This parameter is supported for compatibility only. The value is NULL. |