DBA_PART_TABLES v17
The DBA_PART_TABLES view provides information about all of the partitioned tables in the database.
| Name | Type | Description |
|---|---|---|
owner | TEXT | Owner of the partitioned table. |
schema_name | TEXT | Schema in which the table resides. |
table_name | TEXT | Name of the table. |
partitioning_type | TEXT | Type used to define table partitions. |
subpartitioning_type | TEXT | Subpartitioning type used to define table subpartitions. |
partition_count | BIGINT | Number of partitions in the table. |
def_subpartition_count | INTEGER | Number of subpartitions in the table. |
partitioning_key_count | INTEGER | Number of partitioning keys specified. |
subpartitioning_key_count | INTEGER | Number of subpartitioning keys specified. |
status | CHARACTER VARYING(8) | Provided only for compatibility. Always VALID. |
def_tablespace_name | CHARACTER VARYING(30) | Provided only for compatibility. Always NULL. |
def_pct_free | NUMERIC | Provided only for compatibility. Always NULL. |
def_pct_used | NUMERIC | Provided only for compatibility. Always NULL. |
def_ini_trans | NUMERIC | Provided only for compatibility. Always NULL. |
def_max_trans | NUMERIC | Provided only for compatibility. Always NULL. |
def_initial_extent | CHARACTER VARYING(40) | Provided only for compatibility. Always NULL. |
def_next_extent | CHARACTER VARYING(40) | Provided only for compatibility. Always NULL. |
def_min_extents | CHARACTER VARYING(40) | Provided only for compatibility. Always NULL. |
def_max_extents | CHARACTER VARYING(40) | Provided only for compatibility. Always NULL. |
def_pct_increase | CHARACTER VARYING(40) | Provided only for compatibility. Always NULL. |
def_freelists | NUMERIC | Provided only for compatibility. Always NULL. |
def_freelist_groups | NUMERIC | Provided only for compatibility. Always NULL. |
def_logging | CHARACTER VARYING(7) | Provided only for compatibility. Always YES. |
def_compression | CHARACTER VARYING(8) | Provided only for compatibility. Always NONE. |
def_buffer_pool | CHARACTER VARYING(7) | Provided only for compatibility. Always DEFAULT. |
ref_ptn_constraint_name | CHARACTER VARYING(30) | Provided only for compatibility. Always NULL. |
interval | CHARACTER VARYING(1000) | Provided only for compatibility. Always NULL. |