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
/

  • June 29, 2016 | 12 views
  • Comments