Help Center> Data Warehouse Service> Developer Guide> System Catalogs and System Views> System Views> DBA_TAB_PARTITIONS
DBA_TAB_PARTITIONS
DBA_TAB_PARTITIONS displays information about all partitions in the database.
| 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 |
Parent topic: System Views
Last Article: DBA_TAB_COMMENTS
Next Article: DBA_TABLES
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.