gather_table_stats and interval partitions
I am not able to find the answer on the web so I'm hoping someone here has it. I am trying to figure out how to use dbms_stats.gather_table_stats to analyze one partition of a table with interval partitions. Specifically, is there a way to use the for to_date clause instead of a partition name the way it is used in select statements
select * from owner.table for (to_date('10-20-2010','mm-yy-yyyy'))
instead of
select * from owner.table partition (SYS_1234);
Before we switched to the interval partitions our partition names all had the same standard name - PYYYYMM, with interval partitions the names are system generated and I would rather use the for to_date clause, but I am not sure how to do that or whether it is possible at all.