Oracle Database Discussions

Hello All,

I am bit surprised to see that there isn't a column I can use to query the name of the partition for a table, in case of Internval partition by day..

I am looking for a simple query to find the partition name for the say today's partition.. Am I missing something ?

Query something like..

Select partition_name from dba_Tab_partitions where table_name='XYZ' and TO_DATE(HIGH_VALUE,'DD-MON-YYYY') = '02-APR-2014'

High value being a long column, doesn't let you convert into DATE OR CHAR ??

Thanks in advance