Re: compile invalid objets

Posted by ErmanArslansOracleBlog on
URL: http://erman-arslan-s-oracle-forum.114.s1.nabble.com/compile-invalid-objets-tp1105p1109.html

I checked it again.
This is caused by invalid db objects .
We need to see the real ORA error during the compilations of these invalid objects.

So, the things that I wrote in my previous update still applies.

Compile those invalids also. But before the compilation, check why they get errors..
 Try manual compile for couple of those and see the error. Then try to create an action plan accordingly.

Also, check what is their last DDL time. Think about what did you change before that.
If it was a patch that caused them to be invalid. Investigate the patching actions and logs. Ensure you did everything in patch readme. Also check oracle support for that patch specific known issues and problems.
See the error during your manual compiles and try to understand the real factor lying behind.