我想是有view表达这种依赖关系的,于是，偶打开 dba studio ,进入 方案---视图---sys,然后快速浏览 dba_* 这样的view,根据经验判断很多view不是所需要的,终于看到一个view : dba_dependencies,英文不大利索，猜测可能是。
SQL> desc dba_dependenciesName Null? Type----------------------------------------- -------- ----------------------------OWNER NOT NULL VARCHAR2(30)NAME NOT NULL VARCHAR2(30)TYPE VARCHAR2(17)REFERENCED_OWNER VARCHAR2(30)REFERENCED_NAME VARCHAR2(64)REFERENCED_TYPE VARCHAR2(17)REFERENCED_LINK_NAME VARCHAR2(128)DEPENDENCY_TYPE VARCHAR2(4)select u.name, o.name,decode(o.type#, 0, ''NEXT OBJECT'', 1, ''INDEX'', 2, ''TABLE'', 3, ''CLUSTER'',4, ''VIEW'', 5, ''SYNONYM'', 6, ''SEQUENCE'', 7, ''PROCEDURE'',8, ''FUNCTION'', 9, ''PACKAGE'', 10, ''NON-EXISTENT'',11, ''PACKAGE BODY'', 12, ''TRIGGER'',13, ''TYPE'', 14, ''TYPE BODY'',28, ''JAVA SOURCE'', 29, ''JAVA CLASS'', 56, ''JAVA DATA'',''UNDEFINED''),decode(po.linkname, null, pu.name, po.remoteowner), po.name,decode(po.type#, 0, ''NEXT OBJECT'', 1, ''INDEX'', 2, ''TABLE'', 3, ''CLUSTER'',4, ''VIEW'', 5, ''SYNONYM'', 6, ''SEQUENCE'', 7, ''PROCEDURE'',8, ''FUNCTION'', 9, ''PACKAGE'', 10, ''NON-EXISTENT'',11, ''PACKAGE BODY'', 12, ''TRIGGER'',13, ''TYPE'', 14, ''TYPE BODY'',28, ''JAVA SOURCE'', 29, ''JAVA CLASS'', 56, ''JAVA DATA'',''UNDEFINED''),po.linkname,decode(d.property, 2, ''REF'', ''HARD'')from sys.obj$ o, sys.disk_and_fixed_objects po, sys.dependency$ d, sys.user$ u,sys.user$ puwhere o.obj# = d.d_obj#and o.owner# = u.user#and po.obj# = d.p_obj#and po.owner# = pu.user#
到这里基本已经99% 确认是了,再测试，果然是这个view记录了相关的依赖关系。
下面再说一个我常用的办法，那么多东西要记住很麻烦，我也记不了那么多，有时觉得打开 OEM /dba studio 也很麻烦于是，假如我要查有关 role 相关的东西，于是
SQL> select object_name from dba_objects where object_name like ''%ROLE%'';OBJECT_NAME--------------------------------------------------------------------------------DBA_ROLESDBA_ROLE_PRIVSDEFROLE$I_DEFROLE1JIS$ROLE_TRIGGER$ROLE_ROLE_PRIVSROLE_SYS_PRIVSROLE_TAB_PRIVSSESSION_ROLESUSER_ROLE_PRIVSDBA_ROLESOBJECT_NAME--------------------------------------------------------------------------------DBA_ROLE_PRIVSROLE_ROLE_PRIVSROLE_SYS_PRIVSROLE_TAB_PRIVSSESSION_ROLESUSER_ROLE_PRIVSVBZ$RG_ROLE_OIDXVBZ$ROLE_GRANTS19 rows selected.
大家在这里结果里面一看，是不是就知道哪些视图记录了相关内容？最多，在 desc 看一下，或者再实验来检验一下，这时查文档也可以,很容易就定位了,这是个人在不熟悉view的时候长期使用的一种办法,说起来很简单，但是却很有效！
