Database DataWarehousing (MOSC)

MOSC Banner

gather_table_stats and interval partitions

edited Oct 21, 2010 1:47AM in Database DataWarehousing (MOSC) 4 commentsAnswered
Hello.

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center