upgrade from 10.2.0.1 to 10.2.0.2 gives 100s of invalid objects
- From: Howard Latham <howard.latham@xxxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- 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.
Thoughts ?
--
Howard A. Latham
Sent from my Nokia N97
Other related posts:
