Purpose
This view displays the columns that are part of the partitioning key for all partitioned objects that the user can access.
Applicability
This view applies only to OceanBase Database in Oracle mode.
References
DBA_PART_KEY_COLUMNS
USER_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: |
| 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. |