How to find partition keys for partition table

posted Jun 3, 2012, 8:11 AM by Sachchida Ojha
SQL> select * from USER_PART_KEY_COLUMNS;

NAME                   OBJEC
------------------------------ -----
COLUMN_NAME
--------------------------------------------------------------------------------
COLUMN_POSITION
---------------
F_SALES                TABLE
SALES_AMT

Comments