DBA_PART_KEY_COLUMNS AND DBA_SUBPART_KEY_COLUMNS

posted Feb 1, 2012, 12:36 PM by Sachchida Ojha
 
DBA_PART_KEY_COLUMNS describes the partitioning key columns for all partitioned objects in the database. Its columns are the same as those in ALL_PART_KEY_COLUMNS.

DBA_SUBPART_KEY_COLUMNS lists subpartitioning key columns for all composite-partitioned tables (and local indexes on composite-partitioned tables) in the database. Its columns are the same as those in ALL_SUBPART_KEY_COLUMNS.
 
select * from DBA_PART_KEY_COLUMNS where OWNER='SYS';
select * from DBA_SUBPART_KEY_COLUMNS where OWNER='SYS';
Comments