1、查询表被哪些视图引用
Select owner, object_type, object_name, object_id, status
from sys.DBA_OBJECTS
where object_id in (Select object_id
from public_dependency
connect by prior object_id = referenced_object_id
start with referenced_object_id =
(Select object_id
from sys.DBA_OBJECTS
where owner = 'HEALTHCLOUD'-- 这里放 :Owner
and object_name = 'GK_PERSONINFO' -- 这里放 :name
/*and object_type = :type*/ -- 这里放 TABLE / SYNONYM
) )