upgrade from 10.2.0.1 to 10.2.0.2 gives 100s of invalid objects
Date: Tue, 12 Jul 2011 12:06:58 +0100
Platform Redhat Linux
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.
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