查看哪些对象引用了表或其他对象：REFERENCED_NAME=’T_BIM_ORG’;http://www.cndba.cn/dave/article/2254http://www.cndba.cn/dave/article/2254http://www.cndba.cn/dave/article/2254

set lin 200
set pagesize 200
col REFERENCED_NAME for a20
col OWNER for a15
col name for a40
col REFERENCED_TYPE for a20
col REFERENCED_NAME for a30
SELECT OWNER,NAME,TYPE,REFERENCED_NAME,REFERENCED_TYPE,DEPENDENCY_TYPE FROM DBA_DEPENDENCIES WHERE REFERENCED_NAME='INTER_PD_USERPRC_INFO';

版权声明：本文为博主原创文章，未经博主允许不得转载。