Help Center > > Developer Guide> System Catalogs and System Views> System Views> USER_TAB_PARTITIONS

USER_TAB_PARTITIONS

Updated at: Jul 15, 2020 GMT+08:00

USER_TAB_PARTITIONS displays all table partitions accessible to the current user. Each partition of a partitioned table accessible to the current user has a piece of record in USER_TAB_PARTITIONS.

Table 1 USER_TAB_PARTITIONS columns

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

partition_name

character varying(64)

Name of the table partition

high_value

text

Upper boundary of the table partition

tablespace_name

name

Name of the tablespace of the table partition

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel