摘要：
将远程服务器的一个表映射为本地的一个物化视图，使用下列语句：
----建立测试环境DBLINK:
create database link lnk
connect to user1
identified by pwd1
using '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(Host = 172.17.211.114)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SID= REMOTEDB)))'; 阅读全文
将远程服务器的一个表映射为本地的一个物化视图，使用下列语句：
----建立测试环境DBLINK:
create database link lnk
connect to user1
identified by pwd1
using '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(Host = 172.17.211.114)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SID= REMOTEDB)))'; 阅读全文