| Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-01 |
|
|
View PDF |
| Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-01 |
|
|
View PDF |
ALL_SUBPART_KEY_COLUMNS lists 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 provides this information for all subpartitions in the database.
USER_SUBPART_KEY_COLUMNS provides 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 |
VARCHAR2(30) |
The partitioned table or index owner | |
NAME |
VARCHAR2(30) |
The partitioned table or index name | |
OBJECT_TYPE |
VARCHAR2(11) |
The object type (TABLE or INDEX) |
|
COLUMN_NAME |
VARCHAR2(30) |
The column name | |
COLUMN_POSITION |
NUMBER |
The position of the column within the subpartitioning key |
