Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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_at_gmail.com> 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-lReceived on Wed May 17 2006 - 12:18:25 CDT
![]() |
![]() |