We are trying to create a materialized view with the following statements:
CREATE TABLE agg
(FELD1 NUMBER, FELD2 NUMBER, FELD3 NUMBER, FELD4 NUMBER, d NUMBER);
CREATE MATERIALIZED VIEW LOG ON TESTTABLE WITH ROWID(FELD1, FELD2, FELD3, FELD4) INCLUDING NEW VALUES;
CREATE MATERIALIZED VIEW TESTMATVIEW
REFRESH FAST ON COMMIT
GROUP BY FELD4;
and get the error message: ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized view
Please help me to solve this error
Thanks in advance
I don't think that the fast refresh option for materialised views is valid if the view uses analytic functions - such as SUM.
You might have to use complete refresh.
Just ignore my last post Bala. I just noticed a materialised view example in the Oracle documentation that uses SUM with a FAST REFRESH.
Sorry if I misled you.
Click Here to Expand Forum to Full Width