USER_PART_TABLES
USER_PART_TABLES displays information about partitioned tables accessible to the current user.
Name |
Type |
Description |
---|---|---|
table_owner |
character varying(64) |
Name of the owner of the partitioned table |
schema |
character varying(64) |
Schema of the partitioned table |
table_name |
character varying(64) |
Name of the partitioned table |
partitioning_type |
text |
Partition policy of the partitioned table
NOTE:
Currently, only range partitioning and list partitioning are supported. |
partition_count |
bigint |
Number of partitions of the partitioned table |
def_tablespace_name |
name |
Tablespace name of the partitioned table |
partitioning_key_count |
integer |
Number of 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