I am trying to create a MV as
create materialized view MV_MAXPRICEDATE_STOCKPRICE
refresh complete on commit
enable query rewrite
But it gives me the following error.
ERROR at line 8:
ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized view
I know its because of the max function. If I use sum instead of max it works fine.
Why does Oracle have this limitation and is there any workaround to it because I dont want to refresh My MV manually.
That will be a pain in the ...... you know what :-)