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 :-)
You can if you think you can.
I have made a test, It worked fine as your situation.
Check page 120/618 of Data Warehousing Guide.
Oracle Certified Master - September, 2003, the Second OCM in China
*** LOOKING for PART TIME JOB***
Data Warehouse & Business Intelligence Expert
MCSE, CCNA, SCJP, SCSA from 1998
Click Here to Expand Forum to Full Width