MY_TAB_PARTITIONS

MY_TAB_PARTITIONS displays all table partitions accessible to the current user. Each table partition of a partitioned table accessible to the current user has one record in USER_TAB_PARTITIONS. This view exists in both the PG_CATALOG and SYS schemas.

**Table 1** MY_TAB_PARTITIONS 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.
partition_name	character varying(64)	Partition name.
high_value	text	Limit of a partition. NOTE: For range partitioning and interval partitioning, the upper limit of each partition is displayed. For list partitioning, the value list of each partition is displayed. For hash partitioning, the number of each partition is displayed.
tablespace_name	name	Tablespace name of a partition.
schema	character varying(64)	Schema of a partitioned table.
subpartition_count	bigint	Number of level-2 partitions.
high_value_length	integer	Length of the partition boundary value expression.