Re: Procedure Invalid - Urgent

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@xxxxxxxxx> wrote: 
Peter

I checked and no procedure/Package is dropping any objects. Recylebin is
also empty.

Thanks for help
Sanjay


Peter McLarty <Peter_McLarty@xxxxxxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Sanjay Mishra
Sent: Thursday, 12 October 2006 9:16 AM
To: oracle-l@xxxxxxxxxxxxx
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


Other related posts: