关于建立物化视图的有关问题,请帮忙看看,多谢
关于建立物化视图的问题,请帮忙看看,谢谢
用户:test1,用户:test2
test1下有A表
test2下有B表
create materialized view log on test2.B tablespace test with rowid;
create materialized view log on A tablespace test with rowid;
create materialized view mv_test
refresh
fast
on commit
with rowid as
select t.rowid arowid,f.rowid browid,f.pic_name from A t,test2.B f where t.id=f.id;
这个查询没有问题,但是我要是更新test2用户下的B表时报错,提示如下:
这是为什么?
------解决方案--------------------
Setting _MV_REFRESH_USE_STATS to TRUE can cause ORA-12008 / ORA-942 error
for on-commit XID based refresh
检查一下 _MV_REFRESH_USE_STATS 参数的值
用户:test1,用户:test2
test1下有A表
test2下有B表
create materialized view log on test2.B tablespace test with rowid;
create materialized view log on A tablespace test with rowid;
create materialized view mv_test
refresh
fast
on commit
with rowid as
select t.rowid arowid,f.rowid browid,f.pic_name from A t,test2.B f where t.id=f.id;
这个查询没有问题,但是我要是更新test2用户下的B表时报错,提示如下:
这是为什么?
------解决方案--------------------
Setting _MV_REFRESH_USE_STATS to TRUE can cause ORA-12008 / ORA-942 error
for on-commit XID based refresh
检查一下 _MV_REFRESH_USE_STATS 参数的值