Check the partition keys for partitioned table

Check the partition keys for partition table present in Oracle. It will describes the partitioning key columns for all tables in 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;