这个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>