Purpose
The DBA_PART_KEY_COLUMNS view displays the partitioning key columns of all partitioned objects in the database.
Note
This view is introduced since OceanBase Database V2.2.77.
Related views
ALL_PART_KEY_COLUMNSUSER_PART_KEY_COLUMNS
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| OWNER | VARCHAR2(128) | NO | The owner of the partitioned table or index. |
| NAME | VARCHAR2(128) | NO | The name of the partitioned table or index. |
| OBJECT_TYPE | CHAR(5) | NO | The type of the partitioned object. Valid values: |
| COLUMN_NAME | VARCHAR2(4000) | NO | The name of the column. |
| COLUMN_POSITION | NUMBER | NO | The position of the column in the partitioning key. |
| COLLATED_COLUMN_ID | NUMBER | NO | At present, this column is not supported and is NULL by default. |
