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 a range partition or boundary value set of a list partition Reserved field for forward compatibility. The parameter pretty_high_value is added in version 8.1.3 to record the information. |
pretty_high_value |
text |
Upper boundary of a range partition or boundary value set of a list partition The query result is the instant decompilation output of the partition boundary expression. The output of this column is more detailed than that of high_value. The output information can be collation and column data type. |
tablespace_name |
name |
Name of the tablespace that contains the partition |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot