The DBA_SUBPART_KEY_COLUMNS view provides the information about the key columns of those partitioned tables which are subpartitioned in the database.
| Parameter | Type | Description |
|---|---|---|
| owner | TEXT | The owner of the table. |
| Schema_name | TEXT | The name of the schema to which the table belongs. |
| name | TEXT | The name of the table to which the column belongs. |
| object_type | CHARACTER(5) | This parameter is supported for compatibility only. The value is TABLE. |
| column_name | TEXT | The name of the column on which the key is defined. |
| column_position | INTEGER | The position of this column. For example, a value of 1 indicates the first column and a value of 2 indicates the second column. All columns follow the same rule. |