I am trying to create MV:
CREATE SNAPSHOT "OUTCOME"
ENABLE QUERY REWRITE
GROUP BY ProjectID;
but I have this error msg:
ERROR at line 13:
ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized view
anyone has idea please ?
If I've taken out Sum() it is Ok. But can't create with Sum() - don't know why. Other views with Sum() works.
just found the problem in DataWarehouse Doc:
Restrictions on Fast Refresh on Materialized Views with Single-Table Aggregates:
If VARIANCE(expr) or STDDEV(expr) is specified, you must have COUNT(expr) and SUM(expr).
it works after I've added count() there.
Click Here to Expand Forum to Full Width