The ALL_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.