ADM_PART_TABLES

ADM_PART_TABLES displays information about all partitioned tables in the database. By default, only the system administrator can access this view. Common users can access the view only after being authorized. This view exists in both PG_CATALOG and SYS schema.

**Table 1** ADM_PART_TABLES columns
Name	Type	Description
table_owner	character varying(64)	Owner name of a partitioned table.
table_name	character varying(64)	Name of the partitioned table.
partitioning_type	text	Partitioning policy of the partitioned table. NOTE: For details about the supported partitioning policies of the current partitioned table, see CREATE TABLE PARTITION.
partition_count	bigint	Number of partitions of the partitioned table.
partitioning_key_count	integer	Number of partition keys of the partitioned table.
def_tablespace_name	name	Tablespace name of the partitioned table.
schema	character varying(64)	Schema of the partitioned table.
subpartitioning_type	text	Partitioning policy of a level-2 partitioned table. If the partitioned table is a level-1 partitioned table, NONE is displayed. The distributed system does not support level-2 partitions. Set this parameter to NONE.
def_subpartition_count	integer	Default number of level-2 partitions to be created. The value is 1 for a level-2 partitioned table and 0 for a level-1 partitioned table. The distributed system does not support level-2 partitions. Set this parameter to 0.
subpartitioning_key_count	integer	Number of level-2 partition keys of the partitioned table. The distributed system does not support level-2 partitions. Set this parameter to 0.
status	character varying(8)	Not supported. Its value is valid.
def_pct_free	numeric	Default value of PCTFREE used when a partition is added.
def_pct_used	numeric	Not supported. Its value is NULL.
def_ini_trans	numeric	Default value of INITRANS used when a partition is added.
def_max_trans	numeric	Default value of MAXTRANS used when a partition is added.
def_initial_extent	character varying(40)	Not supported. Its value is NULL.
def_next_extent	character varying(40)	Not supported. Its value is NULL.
def_min_extents	character varying(40)	Not supported. Its value is NULL.
def_max_extents	character varying(40)	Not supported. Its value is NULL.
def_max_size	character varying(40)	Not supported. Its value is NULL.
def_pct_increase	character varying(40)	Not supported. Its value is NULL.
def_freelists	numeric	Not supported. Its value is NULL.
def_freelist_groups	numeric	Not supported. Its value is NULL.
def_logging	character varying(7)	Not supported. Its value is NULL.
def_compression	character varying(8)	Default compression mode used when a partition is added. Value range: NONE ENABLED DISABLED
def_compress_for	character varying(30)	Default compression mode used when a partition is added. NOTE: For available compression modes and compression levels, see WITH ( { storage_paramet...
def_buffer_pool	character varying(7)	Not supported. Its value is DEFAULT.
def_flash_cache	character varying(7)	Not supported. Its value is NULL.
def_cell_flash_cache	character varying(7)	Not supported. Its value is NULL.
ref_ptn_constraint_name	character varying(128)	Not supported. Its value is NULL.
interval	character varying(1000)	Interval.
autolist	character varying(3)	Not supported. Its value is NO.
interval_subpartition	character varying(1000)	Not supported. Its value is NULL.
autolist_subpartition	character varying(3)	Not supported. Its value is NO.
is_nested	character varying(3)	Not supported. Its value is NO.
def_segment_creation	character varying(4)	Currently, the segment page mode is not supported. When the segment page mode is enabled, set it to YES.
def_indexing	character varying(3)	Not supported. Its value is ON.
def_inmemory	character varying(8)	Not supported. Its value is NONE.
def_inmemory_priority	character varying(8)	Not supported. Its value is NULL.
def_inmemory_distribute	character varying(15)	Not supported. Its value is NULL.
def_inmemory_compression	character varying(17)	Not supported. Its value is NULL.
def_inmemory_duplicate	character varying(13)	Not supported. Its value is NULL.
def_read_only	character varying(3)	Not supported. Its value is NO.
def_cellmemory	character varying(24)	Not supported. Its value is NULL.
def_inmemory_service	character varying(12)	Not supported. Its value is NULL.
def_inmemory_service_name	character varying(1000)	Not supported. Its value is NULL.