如果要创建在192.168.30.11 中视图用户应该对oradb 中的表A,B有访问权限select 字段1,字段2 from A@dblink_name
昨天试过 不行 SQL> create view v_test as 2 select pn as upt_n, isd as upt_sd from [email protected]; select pn as upt_n, isd as upt_sd from [email protected] * 第 2 行出现错误: ORA-02019: 未找到远程数据库的连接说明
SQL> create view v_test as
2 select pn as upt_n, isd as upt_sd from [email protected];
select pn as upt_n, isd as upt_sd from [email protected]
*
第 2 行出现错误:
ORA-02019: 未找到远程数据库的连接说明