摘要: 将远程服务器的一个表映射为本地的一个物化视图,使用下列语句: ----建立测试环境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)))'; 阅读全文
posted @ 2012-12-14 14:04 邀月 阅读(6479) 评论(1) 推荐(0) 编辑