查找相关对象

--相关对象
select owner,object_name,object_type,to_char(last_ddl_time,'yyyy-mm-dd hh24:mi:ss') ddl_time 
from dba_objects where object_name in
(select p.name
from sys.obj$ d, sys.dependency$ dep, sys.obj$ p
where d.obj# = dep.d_obj# and p.obj# = dep.p_obj#
start with d.name='&object_name'
connect by prior dep.p_obj#=dep.d_obj#)
order by ddl_time desc;