Query to Find on which column a table is Partitioned

Friday, April 25, 2014

Query to Find on which column a table is Partitioned

SELECT *
  FROM dba_part_key_columns a
 WHERE a.owner = 'TABLE_OWNER' AND a.NAME = 'TABLE_NAME'

Error 404

The page you were looking for, could not be found. You may have typed the address incorrectly or you may have used an outdated link.

Go to Homepage