ALL_SUBPART_KEY_COLUMNS
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_COLUMNSdisplays this information for all subpartitions in the database. -
USER_SUBPART_KEY_COLUMNSdisplays this information for subpartitions of all partitioned objects owned by the current user. This view does not display theOWNERcolumn.
| Column | Datatype | NULL | Description |
|---|---|---|---|
OWNER |
VARCHAR2(128) |
Owner of the partitioned table or index | |
NAME |
VARCHAR2(128) |
Name of the partitioned table or index | |
OBJECT_TYPE |
CHAR(5) |
Object type:
|
|
COLUMN_NAME |
VARCHAR2(4000) |
Column name | |
COLUMN_POSITION |
NUMBER |
Position of the column within the subpartitioning key | |
COLLATED_COLUMN_ID |
NUMBER |
<p>Internal sequence number of the column for which this column provides linguistic ordering</p> |
See Also: