Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: utlrp.sql 10Gr2 $#@$& arrrhhhhggg!

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

From: rjamya <rjamya_at_gmail.com>
Date: Wed, 17 May 2006 13:18:25 -0400
Message-ID: <9177895d0605171018q3976d60eid8eeb0381a057195@mail.gmail.com>


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-l
Received on Wed May 17 2006 - 12:18:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US