Thanks for the prompt reply.
I tried the earlier suggested method to this particular scenario below but it did not work.

Below is the exact scenario:

I have a table called SALES and it has been altered and partitions have been added to it. This is the way it was altered to add the partitions like I have below:


alter table sales
add partition jan_2000 values less than ('01-feb-2000')

How do I count all the rows in jan_2000 partition using select count(*)?