创建物化视图的时候如果基表有关联,那么怎么样才能让基本COMMIT的时候,物化视图同步更新呢?
例如:
CREATE MATERIALIZED VIEW aaa
refresh complete on commit
with rowid
as
select a.col1,a.col2 from t_tb a left join t_tbc b on a.col3=b.col1
这样创建物化视图是不允许的。这样的查询语句有表关联的怎么样用on commit 刷新方式?
例如:
CREATE MATERIALIZED VIEW aaa
refresh complete on commit
with rowid
as
select a.col1,a.col2 from t_tb a left join t_tbc b on a.col3=b.col1
这样创建物化视图是不允许的。这样的查询语句有表关联的怎么样用on commit 刷新方式?
http://blog.csdn.net/suncrafted/archive/2009/06/26/4300358.aspx
http://topic.csdn.net/u/20091225/14/e225f4f6-03f6-4684-b82b-45d58e045ad5.html?seed=2012731555&r=62218282#r_62218282
http://blog.csdn.net/tianlesoftware/archive/2009/10/23/4713553.aspx------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q 群:62697716
刷新模式为on commit模式
CREATE MATERIALIZED VIEW aa_log on t_tb with rowid;CREATE MATERIALIZED VIEW aaaa REFRESH complete
AS
select a.col1,a.col2 from t_tb a left join t_tbc b on a.col3=b.col1 ;