ORA-32314: REFRESH FAST unsupported after update/delete
520501Dec 11 2006 — edited Dec 11 2006My mat view is:
CREATE MATERIALIZED VIEW sal_dept_mv
NOLOGGING
PARALLEL
BUILD IMMEDIATE
REFRESH FAST ON DEMAND
ENABLE QUERY REWRITE
AS
SELECT e.job, e.deptno, sum(e.sal)
FROM emp e,
dept d
WHERE e.deptno=d.deptno
GROUP BY e.job, e.deptno;
Works fine if i have only inserts. Gives the about error when there are updates and i need do a complete refresh.
If i change the code from REFRESH FAST ON DEMAND to REFRESH FAST ON COMMIT (without changing anything else) I can see the latest data in my MAT View even for updates and deletes.
Is it doing a complete refresh automatically on commit in case of updates/inserts???
Thanks,
Dushyant