Re: dbms_stats

Oradba Linux wrote:

> Can i copy the stats for a table to another table - one is non-partitioned
> and another will be online redefined into a partitioned table
> Will this work well ? Instead of regathering stats after partitioning the
> table i am thinking of doing this.

Can you do this? Yes.

Should you do this is an entirely different question.

Based on what information do you believe this would be beneficial?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)