Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

ALL_SUBPART_KEY_COLUMNS

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

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