Help Center> Data Warehouse Service> Developer Guide> System Catalogs and System Views> System Views> DBA_PART_TABLES
DBA_PART_TABLES
DBA_PART_TABLES displays information about all partitioned tables in the database. It is accessible only to users with system administrator rights.
| 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 |
Parent topic: System Views
Last Article: DBA_PART_INDEXES
Next Article: DBA_PROCEDURES
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.