Database DataWarehousing (MOSC)

MOSC Banner

Stats timing not matching for partitioned table when using DBMS_REDEFINTION

edited Jan 6, 2014 12:19AM in Database DataWarehousing (MOSC) 1 commentAnswered

Hi,

I am using DBMS_REDEFINITION package to redefine a partitioned table. The stats date is not matching exactly with the source table stats date when I am using copy stats option. The stats date in the target table  is coming of the timestamp when the stats is copied. The timestamp is same for a non partitioned table but for a partitioned table its different.

The patch 9937133 has already been applied which was related to the same issue.

Can you please help me understand whether this is a bug again or this is how the redefinition works?

Thanks,

Vikash

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