看不明 DBA_DEPENDENCIES.REFERENCED_LINK_NAME

[复制链接]
查看11 | 回复1 | 2012-7-12 18:47:29 | 显示全部楼层 |阅读模式
这个VIEW 在创建时, exchbankbizoperatorlog2,明明使用了远程表 EXCHBANKBIZOPERATORLOG, his_EXCHBANKBIZOPERATORLOG为何视图没查询到?
SQL> create or replace view exchbankbizoperatorlog2 as
select * from EXCHBANKBIZOPERATORLOG@link_bank where ExchID = 106
union all
select * from his_EXCHBANKBIZOPERATORLOG@link_bank where ExchID = 106;234
View created.
SQL> select * from dba_dependencies where name=upper('EXCHBANKBIZOPERATORLOG2');
no rows selected
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE11.2.0.4.0Production
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production
SQL> select sysdate from dual;
SYSDATE
-------------------
2016/12/15 16:25:21
SQL>

回复

使用道具 举报

千问 | 2012-7-12 18:47:29 | 显示全部楼层
没用 DB_LINK 时,使用哪个对象,就显示出来了,
SQL> select * from dba_dependencies where name=upper('EXCHBANKBIZOPERATORLOG2');
NAME
TYPE
REFERENCEDREFERENCED_NAME
REFERENCED_TYPE
REFERENCED_LINK_NAME DEPE
------------------------------ ------------------ ----------- ------------------------------ ------------------ -------------------- ----
EXCHBANKBIZOPERATORLOG2
VIEW
BANK_SETTLE EXCHBANKBIZOPERATORLOG
TABLE
HARD
EXCHBANKBIZOPERATORLOG2
VIEW
BANK_SETTLE HIS_EXCHBANKBIZOPERATORLOG TABLE
HARD
SQL>
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
热门排行