select distinct name from sys.all_source where owner='USERNAME' and (type='PROCEDURE' or type = 'FUNCTION') and (text like '%tablename%' or text like '%TABLENAME%'
查dba_dependencies视图。根据REFERENCED_OWNER、REFERENCED_NAME来查。如查用户A的表T被哪些对象依赖 select owner,name,type from dba_dependencies where owner='A' and referenced_name='T';
select owner,name,type from dba_dependencies where owner='A' and referenced_name='T';
可以得到你所希望的
select * from user_source where upper(text) like '%YOURTABLE%'
再进行剔除