Re: utlrp.sql 10Gr2 $#@$& arrrhhhhggg!
- From: rjamya <rjamya@xxxxxxxxx>
- To: post.ethan@xxxxxxxxx
- Date: Wed, 17 May 2006 13:18:25 -0400
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?
--
//www.freelists.org/webpage/oracle-l
Other related posts:
