My application with numerous PUBLIC SYNONYMS and PLSQL objects has always compiled great after builds (Oracle 9i) using utlrp.sql. However, I am trying to get the same to work in 10Gr2 and I run into all sorts of unexplainable issues.
* Run utlrp.sql * Tons of things don't compile. * I compile all invalid public synonyms *manually*. * Run utlrp.sql again, output says everything is compiled. * I check STATUS in DBA_OBJECTS, some objects are INVALID * I compile them manually...now other things are invalid... * I try running utlrp.sql again...endless cycle here.
I have not checked metalink yet, going to now. Anyone else familiar with this sort of thing or any changes in 10G?