Purpose
The view displays the columns that are part of the partitioning key of all partitioned objects that belong to the current user.
Applicability
This view applies only to OceanBase Database in Oracle mode.
References
DBA_PART_KEY_COLUMNS
ALL_PART_KEY_COLUMNS
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| NAME | VARCHAR2(128) | NO | The name of the partitioned table or index. |
| OBJECT_TYPE | CHAR(5) | NO | The type of the partitioned object:
|
| 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 | This field is currently not supported and is set to NULL by default. |