Feature
USER_SUBPART_KEY_COLUMNS describes subpartitioning key columns for all partitioned objects owned by the current user.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Related views
DBA_SUBPART_KEY_COLUMNS
ALL_SUBPART_KEY_COLUMNS
Fields
| Field | 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. 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 field is not supported and is NULL by default. |