Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Invalid objects

Vinay KOct 10 2012 — edited Oct 14 2012

I am planning to upgrade a db from 10g to 11g. I am making a rough estimate of the timing for this.

I want to clarify few things:

1. Does upgrade invalidates all objects (ie user and dict) and then Validates them ?

2. Does the statistics in 10g usable in 11g ? Do we need to collect fresh stats (for both user and dict tables)

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 11 2012

Added on Oct 10 2012

#database-upgrade

3 comments

148 views