Find the table partition keys - oracle database script

Find the table partition keys - Oracle Database Script.

--- describes the partitioning key columns for all partitioned objects of a schema set pagesize 200 set lines 200 set long 999 col owner for a12 col name for a20 col object_type for a20 col column_name for a32 SELECT   owner, NAME, OBJECT_TYPE,column_name  FROM dba_part_key_columns where owner='&OWNER' ORDER BY owner, NAME;