The ALL_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 name of 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.