Note
This view is available starting with V2.2.77.
Purpose
This view displays all columns in the subpartition key of all partitioned objects in the current tenant.
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 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 in the subpartition key of the partitioned table TBL2_F_RL in the current user's tenant.
obclient [SYS]> SELECT * FROM SYS.DBA_SUBPART_KEY_COLUMNS WHERE NAME='TBL2_F_RL';
The query result is as follows:
+-------+-----------+-------------+-------------+-----------------+--------------------+
| OWNER | NAME | OBJECT_TYPE | COLUMN_NAME | COLUMN_POSITION | COLLATED_COLUMN_ID |
+-------+-----------+-------------+-------------+-----------------+--------------------+
| SYS | TBL2_F_RL | TABLE | COL2 | 1 | NULL |
+-------+-----------+-------------+-------------+-----------------+--------------------+
1 row in set
References
Query all columns in the subpartition key of all partitioned objects in all tenants: CDB_SUBPART_KEY_COLUMNS
Query all columns in the subpartition key of all partitioned objects accessible to the current user: ALL_SUBPART_KEY_COLUMNS
Query all columns in the subpartition key of all partitioned objects owned by the current user: USER_SUBPART_KEY_COLUMNS