我用脚本成功创建了一个物化视图:
CREATE MATERIALIZED VIEW orderitem_mvmt
BUILD IMMEDIATE
REFRESH FAST
ON DEMAND
AS
select * from order_item;
试图提高性能我改变了这样
CREATE MATERIALIZED VIEW orderitem_mvmt
BUILD IMMEDIATE
REFRESH FAST
ON DEMAND
AS
select * from order_item
where to_char(last_upd,'yyyy') between to_char(sysdate,'yyyy')-3 and to_char(sysdate,'yyyy')+3;
运行脚本会引发错误 ORA-12015: cannot create a fast refresh materialized view from a complex query
我不明白它如何与快速刷新相匹配Restrictions
谢谢 .
1 回答
看看General Restrictions on Fast Refresh
您的查询包含
SYSDATE
因此您无法将其用于FAST REFRESH