How to get oldest partition in a table.

rishireddy

Hi,
I need to delete the oldest partition in a table whenever the disk space crosses certain limit.
So could anyone help me out how to get oldest partition in a table so that i could drop that particular partition.

TomM

try select projection_name, partition_key from partitions order by partition_key desc;