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