Compiling All Objects
Hi All,
We have just upgraded DEV and TEST databases from 10.2.0.3 to 10.2.0.4. This raised what looked like Bug 6685261 so I applied 10.2.0.4 P12 which fixed that problem, unfortunately it raised another.
It looks like 10.2.0.3 was not as strict as it could have been in policing ambiguously defined columns (ORA-00918) and 10.2.0.4 has picked this up and shut ther door. Given this, I want to recompile all non-system objects in the 10.2.0.4 databases to find the culprits existing in 10.2.0.3 so we can narrow down our testing post upgrade. A couple of hours with Mr Google and "Metalink" have given me no results. I have tried setting the status of some objects to 3 in sys.obj$ to force the compilation. When I select all invalid objects from dba_objects the "updated"ones appear