Skip to content
Advertisement

Best way to get high value of partition from oracle database?

Best way to get high value of partition from oracle database?

Advertisement

Answer

“Best” is subjective but you can retrieve the high values by quering the data dictionary:

SELECT partition_name,
       high_value
FROM   USER_TAB_PARTITIONS
WHERE  table_name = 'YOUR_TABLE_NAME';
User contributions licensed under: CC BY-SA
9 People found this is helpful
Advertisement