Database Administration (MOSC)

MOSC Banner

How to create a materialized view refresh fast on commit with outer join and group by?

edited Oct 23, 2018 11:24AM in Database Administration (MOSC) 2 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center