dba_dependencies视图的查询结果
分类：Oracle DB
dba_dependencies
[oracle@rhel63single ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Fri Mar 13 09:11:24 2015Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> col owner format a15SQL> col name format a15SQL> col REFERENCED_NAME format a30SQL> col REFERENCED_OWNER format a16SQL> col REFERENCED_LINK_NAME format a30SQL> set line 200SQL> select * from dba_dependencies where NAME LIKE '%V_SAL%';OWNERNAMETYPEREFERENCED_OWNER REFERENCED_NAMEREFERENCED_TYPE REFERENCED_LINK_NAMEDEPENDENCY_TYPE ————— ————— —————— ————— —————————— —————— —————————— —————SCOTTV_SALVIEWSCOTTDEPTTABLEHARDSCOTTV_SALVIEWSCOTTEMPTABLEHARDSYSTEMSYN_V_SALSYNONYMSCOTTV_SALVIEWHARDSQL>
CREATE SYNONYM SYSTEM.SYN_V_SAL FOR SCOTT.V_SAL
上一篇在drop user之前，建议获取该用户的依赖情况
顶0踩0
，不知道来年，会不会开出一地的记忆和忧愁。
