Re: utlrp.sql 10Gr2 $#@$& arrrhhhhggg!

EP,

we use our own script to compile, we added synonyms part to it for 10g
databases. There are some objects related to AWR that get invalid
because of periodic partition maintenance. Ignore those, as they will
compile themselves.

Raj

On 5/17/06, Ethan Post <post.ethan@xxxxxxxxx> wrote: 


* 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.

--
----------------------------------------------
Got RAC?
--
http://www.freelists.org/webpage/oracle-l


Other related posts: