ORA-12052: cannot fast refresh materialized view DCS_BIZ.MV_TMP_16
来源:互联网 发布:程序员和美工谁收入高 编辑:程序博客网 时间:2024/06/14 06:32
CREATE MATERIALIZED VIEW LOG ON tmp_mv1
WITH rowid
INCLUDING NEW VALUES;
WITH rowid
INCLUDING NEW VALUES;
SQL> create materialized view MV_TMP_16
2 refresh fast on demand
3 start with to_date('14-02-2014 17:03:16', 'dd-mm-yyyy hh24:mi:ss') next SYSDATE+ 3/1440
4 enable query rewrite
5 as
6 select SO.ID,so.name, CO.Pid,co.id as co_id
7 from tmp_mv1 SO, tmp_mv2 CO
8 where SO.ID= CO.pid;
create materialized view MV_TMP_16
refresh fast on demand
start with to_date('14-02-2014 17:03:16', 'dd-mm-yyyy hh24:mi:ss') next SYSDATE+ 3/1440
enable query rewrite
as
select SO.ID,so.name, CO.Pid,co.id as co_id
from tmp_mv1 SO, tmp_mv2 CO
where SO.ID= CO.pid
ORA-12052: cannot fast refresh materialized view DCS_BIZ.MV_TMP_16
2 refresh fast on demand
3 start with to_date('14-02-2014 17:03:16', 'dd-mm-yyyy hh24:mi:ss') next SYSDATE+ 3/1440
4 enable query rewrite
5 as
6 select SO.ID,so.name, CO.Pid,co.id as co_id
7 from tmp_mv1 SO, tmp_mv2 CO
8 where SO.ID= CO.pid;
create materialized view MV_TMP_16
refresh fast on demand
start with to_date('14-02-2014 17:03:16', 'dd-mm-yyyy hh24:mi:ss') next SYSDATE+ 3/1440
enable query rewrite
as
select SO.ID,so.name, CO.Pid,co.id as co_id
from tmp_mv1 SO, tmp_mv2 CO
where SO.ID= CO.pid
ORA-12052: cannot fast refresh materialized view DCS_BIZ.MV_TMP_16
解决方案:
create materialized view MV_TMP_16
refresh fast on demand
start with to_date('14-02-2014 17:03:16', 'dd-mm-yyyy hh24:mi:ss') next SYSDATE+ 3/1440
enable query rewrite
as
select SO.rowid arowid, CO.rowid browid, SO.ID,so.name, CO.Pid,co.id as co_id
from tmp_mv1 SO, tmp_mv2 CO
where SO.ID= CO.pid;
refresh fast on demand
start with to_date('14-02-2014 17:03:16', 'dd-mm-yyyy hh24:mi:ss') next SYSDATE+ 3/1440
enable query rewrite
as
select SO.rowid arowid, CO.rowid browid, SO.ID,so.name, CO.Pid,co.id as co_id
from tmp_mv1 SO, tmp_mv2 CO
where SO.ID= CO.pid;
注:这里必须要加上rowid,否则就会报错
0 0
- ORA-12052: cannot fast refresh materialized view DCS_BIZ.MV_TMP_16
- ORA-12032: cannot use rowid column from materialized view log on "DCS_BIZ"."TMP_12"
- ORA-23413: table "DCS_BIZ"."TMP_12" does not have a materialized view log
- ERROR at line 1: ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized view
- MATERIALIZED VIEW 的Refresh
- How to refresh materialized view in oracle
- materialized view
- materialized view
- MATERIALIZED VIEW
- materialized view
- materialized view
- MATERIALIZED VIEW
- Materialized View
- ORA-02243: ALTER INDEX 或 ALTER MATERIALIZED VIEW 选项无效
- Drop Materialized View with Fails with ORA-4020 and getting ORA-955 while Recreating MVIEW
- materialized view(1)
- oracle materialized view
- Oracle中Materialized View
- mongodb:在mongo终端上操作将数据从一个字段复制到另一个字段上。
- OpenGL 4.0 GLSL 用立方体贴图和 环境贴图 模拟反射效果
- 用html5开发随机生成的大树的代码
- day24
- tftp 在ubuntu12.04, busyBox上的配置和使用
- ORA-12052: cannot fast refresh materialized view DCS_BIZ.MV_TMP_16
- UITextView
- 邮箱自动填充js
- c++ 产生随机数
- Oracle索引原理
- 通途 - 爱商
- shell算数运算
- MatLab基础知识小结
- spring四种依赖注入方式