创建物化视图的SQL如下:
create materialized view v_outreserve_2 refresh fast on commit
as
select iv.m_inventory_id, iv.documentno, ivline.m_inventoryline_id,
ivline.m_product_id, ivline.m_locator_id, ma.m_attributesetinstance_id, ma.movementqty, '内部使用库存'
from M_InventoryLineMA ma
inner join M_InventoryLine ivline on ma.M_InventoryLine_id = ivline.M_InventoryLine_id
inner join M_Inventory iv On iv.m_Inventory_Id = ivline.m_Inventory_Id
where iv.C_DocType_ID = 1000021
运行后报ora-12054 无法为实体化视图设置on commit刷新属性错误,
如果把上面SQL的refresh fast on commit注释,可以创建默认的物化视图。
请问select语句应该怎么写?refresh fast on commit 的物化视图应怎样创建?
create materialized view v_outreserve_2 refresh fast on commit
as
select iv.m_inventory_id, iv.documentno, ivline.m_inventoryline_id,
ivline.m_product_id, ivline.m_locator_id, ma.m_attributesetinstance_id, ma.movementqty, '内部使用库存'
from M_InventoryLineMA ma
inner join M_InventoryLine ivline on ma.M_InventoryLine_id = ivline.M_InventoryLine_id
inner join M_Inventory iv On iv.m_Inventory_Id = ivline.m_Inventory_Id
where iv.C_DocType_ID = 1000021
运行后报ora-12054 无法为实体化视图设置on commit刷新属性错误,
如果把上面SQL的refresh fast on commit注释,可以创建默认的物化视图。
请问select语句应该怎么写?refresh fast on commit 的物化视图应怎样创建?
create materialized view log on t ;
create materialized view mv
REFRESH FAST ON COMMIT
as select * from t;
dbms_mview.explain_mview查看你的MVIEW为什么不能fresh on commit;