Purpose
This view displays the columns that are part of the subpartitioning key of all partitioned objects that the user has access to.
Applicability
This view applies only to OceanBase Database in Oracle mode.
References
DBA_SUBPART_KEY_COLUMNS
USER_SUBPART_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 subpartitioning key. |
| COLLATED_COLUMN_ID | NUMBER | NO | Currently, this field is not supported. The default value is NULL. |