| Oracle® Database Reference 11g Release 2 (11.2) Part Number E17110-08 |
|
|
PDF · Mobi · ePub |
| Oracle® Database Reference 11g Release 2 (11.2) Part Number E17110-08 |
|
|
PDF · Mobi · ePub |
ALL_PART_KEY_COLUMNS describes the partitioning key columns for the partitioned objects accessible to the current user.
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 the OWNER column.
| Column | Datatype | NULL | Description |
|---|---|---|---|
OWNER |
VARCHAR2(30) |
Owner of the partitioned table or index | |
NAME |
VARCHAR2(30) |
Name of the partitioned table or index | |
OBJECT_TYPE |
CHAR(5) |
Object type:
|
|
COLUMN_NAME |
VARCHAR2(4000) |
Name of the column | |
COLUMN_POSITION |
NUMBER |
Position of the column within the partitioning key |
|
 Copyright © 2002, 2011, Oracle and/or its affiliates. All rights reserved. Legal Notices |
|
