3.4 ALL_PART_KEY_COLUMNS
ALL_PART_KEY_COLUMNS
describes the partitioning key columns for the partitioned objects accessible to the current user.
Related Views
-
DBA_PART_KEY_COLUMNS
describes the partitioning key columns for all partitioned objects in the database. -
USER_PART_KEY_COLUMNS
describes the partitioning key columns for the partitioned objects owned by the current user. This view does not display theOWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the partitioned table or index |
|
|
|
Name of the partitioned table or index |
|
|
|
Object type:
|
|
|
|
Name of the column |
|
|
|
Position of the column within the partitioning key |
|
|
|
Internal sequence number of the column for which this column provides linguistic ordering |
See Also: