给物化视图设置自动快速刷新功能失败

为什么我把基表和物化视图建在同一个库上可以给物化视图设置自动快速刷新功能,但是如果基表在另一个库上,物化视图通过dblink连接基表,就不能设置自动快速刷新功能,创建的时候报错:
ERROR at line 1:
ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized view
数据库是10.2.0.1,脚本在下面,请大侠帮忙看看啊,谢谢哈!
成功脚本是:
PROD1@PROD>create table t1 (x int,y int,z int);  
Table created.
PROD1@PROD>insert into t1 values (1,2,3);
1 row created.
PROD1@PROD>insert into t1 values (4,5,6);
1 row created.
PROD1@PROD>commit;
Commit complete.
PROD1@PROD>create materialized view log on t1 with sequence,rowid (x,y,z) including new values;
Materialized view log created.
PROD1@PROD>create materialized view mv_t1 build immediate refresh with rowid fast on commit enable query rewrite as select x,y from t1;
Materialized view created.
失败脚本是:
PROD2@PROD2>create table t1 (x int,y int,z int);  
PROD2@PROD2>insert into t1 values (1,2,3);
PROD2@PROD2>insert into t1 values (4,5,6);
PROD2@PROD2>commit;
PROD2@PROD2>select * from t1;
PROD2@PROD2>create materialized view log on t1 with sequence,rowid (x,y,z) including new values;
Materialized view log created.
PROD1@PROD>drop materialized view mv_t1;
Materialized view dropped.
PROD1@PROD>create materialized view mv_t1 build immediate refresh with rowid fast on commit enable query rewrite as select x,y from t1@dblink_prod2;
create materialized view mv_t1 build immediate refresh with rowid fast on commit enable query rewrite as select x,y from t1@dblink_prod2
*
ERROR at line 1:
ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized view

 

网上有人说“on commit的一个前提就是物化视图和基表必须处于一个数据库中”。不知道这个说法对不对。

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26521853/viewspace-1097819/,如需转载,请注明出处,否则将追究法律责任。

转载于:http://blog.itpub.net/26521853/viewspace-1097819/

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值