How to create a materialized view refresh fast on commit with outer join and group by?
I am trying to create a materialized view against the ONT.OE_ORDER_LINES_ALL table. Heres my mview log script which created without issue and my mview script. I am getting this error when trying to create the mview: ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized view.
Scripts:
CREATE MATERIALIZED VIEW LOG ON ont.oe_order_lines_all
WITH PRIMARY KEY,
ROWID,
SEQUENCE(HEADER_ID,INVENTORY_ITEM_ID,SHIPPED_QUANTITY,ORDER_QUANTITY_UOM,request_DATE,line_category_code,line_type_id,flow_status_code,RETURN_ATTRIBUTE1,RETURN_ATTRIBUTE2)
INCLUDING NEW VALUES;
Create Materialized View eligible_return_lines_mv