upgrade from 10.2.0.1 to 10.2.0.2 gives 100s of invalid objects

3 Databases on 1 box 2 dbs upgraded ok the other one very old - was once v7 has hundreds of invalid objects
and status of server component invalid.

Can't downgrade as the other 2 are ok.

I have logged an SR and we have tried uninstalling and reinstalling components,

Ideas seem to have run out.

I wonder wherher the 'inavalidity' Matters if all the queries we do work ok.

I also wonder whether I should just go ahead and upgrade to 11 which was why we started upgrade in first place.

This DB is 500gigs of data.

Thoughts ?

--

Howard A. Latham

Sent from my Nokia N97

--

http://www.freelists.org/webpage/oracle-l Received on Tue Jul 12 2011 - 06:06:58 CDT