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 the PG_CATALOG and SYS schemas.

**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 a partitioned table.
partitioning_type	text	Partition policy of a 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 a partitioned table.
partitioning_key_count	integer	Number of partition keys of a partitioned table.
def_tablespace_name	name	Tablespace name of a partitioned table.
schema	character varying(64)	Schema of a partitioned table.
subpartitioning_type	text	Partition 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. Set it to valid.
def_pct_free	numeric	Default value of PCTFREE used when a partition is added.
def_pct_used	numeric	Not supported. Set it to 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. Set it to NULL.
def_next_extent	character varying(40)	Not supported. Set it to NULL.
def_min_extents	character varying(40)	Not supported. Set it to NULL.
def_max_extents	character varying(40)	Not supported. Set it to NULL.
def_max_size	character varying(40)	Not supported. Set it to NULL.
def_pct_increase	character varying(40)	Not supported. Set it to NULL.
def_freelists	numeric	Not supported. Set it to NULL.
def_freelist_groups	numeric	Not supported. Set it to NULL.
def_logging	character varying(7)	Not supported. Set it to NULL.
def_compression	character varying(8)	Default compression mode used when a partition is added. The options are as follows: 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_parameter = value } [, ... ] ).
def_buffer_pool	character varying(7)	Not supported. Set it to DEFAULT.
def_flash_cache	character varying(7)	Not supported. Set it to NULL.
def_cell_flash_cache	character varying(7)	Not supported. Set it to NULL.
ref_ptn_constraint_name	character varying(128)	Not supported. Set it to NULL.
interval	character varying(1000)	Interval.
autolist	character varying(3)	Not supported. Set it to NO.
interval_subpartition	character varying(1000)	Not supported. Set it to NULL.
autolist_subpartition	character varying(3)	Not supported. Set it to NO.
is_nested	character varying(3)	Not supported. Set it to 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. Set it to ON.
def_inmemory	character varying(8)	Not supported. Set it to NONE.
def_inmemory_priority	character varying(8)	Not supported. Set it to NULL.
def_inmemory_distribute	character varying(15)	Not supported. Set it to NULL.
def_inmemory_compression	character varying(17)	Not supported. Set it to NULL.
def_inmemory_duplicate	character varying(13)	Not supported. Set it to NULL.
def_read_only	character varying(3)	Not supported. Set it to NO.
def_cellmemory	character varying(24)	Not supported. Set it to NULL.
def_inmemory_service	character varying(12)	Not supported. Set it to NULL.
def_inmemory_service_name	character varying(1000)	Not supported. Set it to NULL.