MY_PART_TABLES
MY_PART_TABLES displays information about partitioned tables accessible to the current user. This view exists in both the PG_CATALOG and SYS schemas.
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.
NOTE:
For details about the supported partitioning policies of the current level-2 partitioned table, see CREATE TABLE SUBPARTITION. |
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. |
subpartitioning_key_count |
integer |
Number of level-2 partition keys of the partitioned table. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot