|
|
|
|
Re: package going invalid, without modifying dependency [message #401851 is a reply to message #401822] |
Wed, 06 May 2009 11:47   |
JRowbottom
Messages: 5933 Registered: June 2006 Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
Other than setting a package to invalid with DBMS_UTILITY, changing a dependant object is way that objects get set to a status of invalid.
Try running this, and replace 'P_1' with the name of the object you're looking at:select name
,type
,uo1.status
,uo1.last_ddl_time
,referenced_name
,referenced_type
,uo2.status
,uo2.last_ddl_time
from user_dependencies ud
,user_objects uo1
,user_objects uo2
where ud.referenced_name = uo2.object_name
and ud.name = uo1.object_name
connect by prior referenced_name = name
start with name = 'P_1';
|
|
|
|
|
Re: package going invalid, without modifying dependency [message #401888 is a reply to message #401683] |
Wed, 06 May 2009 19:02  |
 |
BlackSwan
Messages: 26766 Registered: January 2009 Location: SoCal
|
Senior Member |
|
|
You state you have a problem.
OK, we will stipulate you have a problem.
Please review what you have posted. Just whines & no facts.
Please review what you have not posted.
Post Operating System (OS) name & version for DB server system.
Post Oracle version to 4 decimal place of database s/w.
>I am facing a issue, where several packages in database got invalid automatically.
Provide proof.
Packages do not spontaneously go invalid. Why is this a problem?
>And each time we saw 'GES Potential blocker' in alert logs, and there were many locked sessions .
So you claim. Is CUT & PASTE broken for you?
Is this happening on a RAC environment?
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.
Post the results from running SQL by JRowbottom (above).
PLEASE answer ALL questions asked of you!
[Updated on: Wed, 06 May 2009 19:12] Report message to a moderator
|
|
|