17,377
社区成员
发帖
与我相关
我的任务
分享
--101
CREATE PUBLIC DATABASE LINK to_205 CONNECT TO tds IDENTIFIED BY wellhope USING '172.16.90.205:1521/orcl';
create view ttttt_1 as
select * from info_user@to_205;
--从102访问101上的view
CREATE PUBLIC DATABASE LINK to_101 CONNECT TO tds IDENTIFIED BY wellhope USING '172.16.90.101:1521/orcl';
SQL> select count(*) from ttttt_1@to_101;
COUNT(*)
----------
1827
SQL>