—-建立测试环境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_DA本文来源gaodai#ma#com搞*!代#%^码网%TA = (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)))';--创建物化视图，每隔两天自动同步更新一次； CREATE MATERIALIZED VIEW DEPARTMENT REFRESH FORCE START WITH SYSDATE NEXT SYSDATE + 2 WITH PRIMARY KEY AS SELECT * FROM user1.DEPARTMENT@lnk WHERE 1＝1;
将远程服务器的一个表映射为本地的一个物化视图，使用下列语句：
结果提示：”ORA-01788: 此查询块中要求 CONNECT BY 子句”。
google无法访问，百度搜索太扯蛋，用必应，总算得到线索，解决方案：
在本地库中执行如下语句：
ALTER SYSTEM SET "_ALLOW_LEVEL_WITHOUT_CONNECT_BY"=TRUE SCOPE=BOTH
OK!
助人等于自助! [email protected]
搞代码网（gaodaima.com）提供的所有资源部分来自互联网，如果有侵犯您的版权或其他权益，请说明详细缘由并提供版权或权益证明然后发送到邮箱[email protected]，我们会在看到邮件的第一时间内为您处理，或直接联系QQ：872152909。本网站采用BY-NC-SA协议进行授权
转载请注明原文链接：Oracle 11g创建远程物化视图时提示“ORA
转载请注明原文链接：Oracle 11g创建远程物化视图时提示“ORA
