MY_PART_TABLES

MY_PART_TABLES displays information about partitioned tables accessible to the current user. This view exists in the PG_CATALOG and SYS schemas.

**Table 1** MY_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.