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: Procedure Invalid - Urgent

Re: Procedure Invalid - Urgent

From: rjamya <rjamya_at_gmail.com>
Date: Wed, 11 Oct 2006 22:15:23 -0400
Message-ID: <9177895d0610111915u39fa18ean937748f8cd6fe873@mail.gmail.com>


since you say recyclebin, I guess you are on 10g, so are those procedures owned by SYS? if so it is normal then due to AWR activity. There is periodic partition add/drop activity and that causes some SYS packages to go invalid. This will NOT affect your production applications. It is documented as such on Metablink.

Or, you are talking about procedures in non SYS schema? HTHs
Raj

On 10/11/06, Sanjay Mishra <smishra_97_at_yahoo.com> wrote:
> Peter
>
> I checked and no procedure/Package is dropping any objects. Recylebin is
> also empty.
>
> Thanks for help
> Sanjay
>
>
> Peter McLarty <Peter_McLarty_at_technologyonecorp.com> wrote:
>
> Hi
>
> Look for something dropping an object these use.
> I had an application that did a batch load and the developers had decided to
> drop a table as part of the clean up of the staging point before loading new
> data. It always invalidated the procedures that were called to load the data
> to its eventual location
> I had them alter the clean up to truncate of the staging tables
>
> HTH
>
> Peter McLarty
> Technical Consultant
> Service Delivery
> Technology One
>
> ________________________________________
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Sanjay Mishra
> Sent: Thursday, 12 October 2006 9:16 AM
> To: oracle-l_at_freelists.org
> Subject: Procedure Invalid - Urgent
>
> I have one application in production where several Procedure become invalid
> at the same time. Can somebody suggest as how I can check as why all become
> invalid. Currently I am running utlrp every 5 minutes so that application is
> not affected. This is the new aplication went live on the weekend,
>
> TIA
> Sanjay
>
> ________________________________________
> Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. Great rates
> starting at 1/min.
>
>
>
> ________________________________
> Stay in the know. Pulse on the new Yahoo.com. Check it out.
>
>

-- 
----------------------------------------------
Got RAC?
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Oct 11 2006 - 21:15:23 CDT

Original text of this message

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