DBA_SUBPART_KEY_COLUMNS v16
The DBA_SUBPART_KEY_COLUMNS
view provides information about the key columns of those partitioned tables that are subpartitioned that reside in the database.
Name | Type | Description |
---|---|---|
owner | TEXT | Owner of the table. |
schema_name | TEXT | Name of the schema in which the table resides. |
name | TEXT | Name of the table in which the column resides. |
object_type | CHARACTER(5) | Only for compatibility. Always TABLE . |
column_name | TEXT | Name of the column on which the key is defined. |
column_position | INTEGER | 1 for the first column, 2 for the second column, and so on. |