DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Wednesday, June 29, 2016

To find the dependent packages or objects related to a package



To find the dependent packages or objects related to a package





Below query is used to find the dependencies for an objects or a package
So we can avoid the invalidation of objects before compilation itself.



set pages 2000
select substr(a.owner,1,10),a.name,a.type,b.status,last_ddl_Time
from
(select distinct owner,name,type from dba_dependencies
where referenced_name = UPPER('&1')
) a,
dba_objects b
where a.name=b.object_name
and   a.owner=b.owner
and   a.type = b.object_type
order by 3
/

No comments: