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

DBA_TAB_PARTITIONS

Updated at: Sep 17, 2021 GMT+08:00

DBA_TAB_PARTITIONS displays information about all partitions in the database.

Table 1 DBA_TAB_PARTITIONS columns

Name

Type

Description

table_owner

character varying(64)

Owner of the table that contains the partition

schema

character varying(64)

Schema of the partitioned table

table_name

character varying(64)

Table name

partition_name

character varying(64)

Name of the partition

high_value

text

Upper boundary of the range partition and interval partition

tablespace_name

name

Name of the tablespace that contains the 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