ALL_SUBPART_KEY_COLUMNS v13
The following table lists the information available in the ALL_SUBPART_KEY_COLUMNS
view:
Column | Type | Description |
---|---|---|
owner | name | The name of the table owner. |
schema_name | name | The name of the schema on which the table resides. |
name | name | The name of the table. |
object_type | character(5) | This column will always be TABLE . |
column_name | name | The name of the partitioning key column. |
column_position | integer | The position of this column within the subpartitioning key (the first column has a column position of 1, the second column has a column position of 2...) |