Stored Procedure : Truncate Partitions by HIGH_VALUE

Hi ! In this case I need to truncate a partition but I don’t know it’s name. This table has a range partition for every month , so I know HIGH_VALUE of particular partition. We can find partition_name in ALL_TAB_PARTITIONS table but HIGH_VALUE column has CLOB data type. We need a script like below for to change …

Stored Procedure : Truncate Partitions by HIGH_VALUE Read More »