ALL_PART_TABLES v13
The following table lists the information available in the ALL_PART_TABLES view:
| Column | Type | Description |
|---|---|---|
owner | name | The owner of the table. |
schema_name | name | The schema in which the table resides. |
table_name | name | The name of the table. |
partitioning_type | text | RANGE, LIST, or HASH. |
subpartitioning_type | text | RANGE, LIST, HASH, or NONE. |
partition_count | bigint | The number of partitions. |
def_subpartition_count | integer | The default subpartition count - this will always be 0. |
partitioning_key_count | integer | The number of columns listed in the partition by clause. |
subpartitioning_key_count | integer | The number of columns in the subpartition by clause. |
status | character varying(8) | This column will always be VALID. |
def_tablespace_name | character varying(30) | This column will always be NULL. |
def_pct_free | numeric | This column will always be NULL. |
def_pct_used | numeric | This column will always be NULL. |
def_ini_trans | numeric | This column will always be NULL. |
def_max_trans | numeric | This column will always be NULL. |
def_initial_extent | character varying(40) | This column will always be NULL. |
def_next_extent | character varying(40) | This column will always be NULL. |
def_min_extents | character varying(40) | This column will always be NULL. |
def_max_extents | character varying(40) | This column will always be NULL. |
def_pct_increase | character varying(40) | This column will always be NULL. |
def_freelists | numeric | This column will always be NULL. |
def_freelist_groups | numeric | This column will always be NULL. |
def_logging | character varying(7) | This column will always be YES. |
def_compression | character varying(8) | This column will always be NONE. |
def_buffer_pool | character varying(7) | This column will always be DEFAULT. |
ref_ptn_constraint_name | character varying(30) | This column will always be NULL. |
interval | character varying(1000) | This column will always be NULL. |