Note
This view is available starting with V2.2.77.
Purpose
This view displays all columns in the primary partitioning key of all partitioned objects owned by the current user.
Applicability
This view is applicable only to OceanBase Database in Oracle mode.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| NAME | VARCHAR2(128) | NO | The name of the partitioned table or partitioned 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 | This column is not supported. It is always NULL. |
Sample query
Query the columns in the primary partitioning key of the partitioned index TBL1_H_IDX1 owned by the current user.
obclient [SYS]> SELECT * FROM SYS.USER_PART_KEY_COLUMNS WHERE NAME='TBL1_H_IDX1';
The query result is as follows:
+-------------+-------------+-------------+-----------------+--------------------+
| NAME | OBJECT_TYPE | COLUMN_NAME | COLUMN_POSITION | COLLATED_COLUMN_ID |
+-------------+-------------+-------------+-----------------+--------------------+
| TBL1_H_IDX1 | INDEX | COL2 | 1 | NULL |
+-------------+-------------+-------------+-----------------+--------------------+
1 row in set