Skip Headers
Oracle® Database Reference
11g Release 1 (11.1)

Part Number B28320-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
Contact Us

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

ALL_PART_KEY_COLUMNS

ALL_PART_KEY_COLUMNS describes the partitioning key columns for the partitioned objects accessible to the current user.

Related Views

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:
  • TABLE

  • INDEX

COLUMN_NAME VARCHAR2(4000)   Name of the column
COLUMN_POSITION NUMBER   Position of the column within the partitioning key