DBA_PART_KEY_COLUMNS v16

The DBA_PART_KEY_COLUMNS view provides information about the key columns of the partitioned tables that reside in the database.

NameTypeDescription
ownerTEXTOwner of the table.
schema_nameTEXTName of the schema in which the table resides.
nameTEXTName of the table in which the column resides.
object_typeCHARACTER(5)Only for compatibility. Always TABLE.
column_nameTEXTName of the column on which the key is defined.
column_positionINTEGER1 for the first column, 2 for the second column, and so on.