Database Administration (MOSC)

MOSC Banner

Compiling All Objects

edited Mar 24, 2010 6:59AM in Database Administration (MOSC) 12 commentsAnswered

 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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center