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

DBA_PART_TABLES

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

DBA_PART_TABLES displays information about all partitioned tables in the database. It is accessible only to users with system administrator rights.

Table 1 DBA_PART_TABLES 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

partitioning_type

text

Partition policy of the partitioned table

NOTE:

Currently, only range partitioning is 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

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