ALL_SUBPART_KEY_COLUMNS
displays subpartitioning key columns for composite-partitioned tables (and local indexes on composite-partitioned tables) accessible to the current user.
Related Views
DBA_SUBPART_KEY_COLUMNS
displays this information for all subpartitions in the database.
USER_SUBPART_KEY_COLUMNS
displays this information for subpartitions of all partitioned objects owned by the current user. This view does not display the OWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
Owner of the partitioned table or index |
|
|
|
Name of the partitioned table or index |
|
|
|
Object type:
|
|
|
|
Column name |
|
|
|
Position of the column within the subpartitioning key |
See Also: