SYSDATE in WHERE condition of "fast refresh on commit" materialized views
236779Jul 18 2007 — edited Jul 19 2007Dear Sirs:
in Oracle 9.2 I have a materialized view working fine with fast refresh on commit.
Now we need to change one of the SELECT conditions from "STILL IN":
...
AND EXIT_DATE is null
...
to "STILL IN OR EXITED IN THE LAST 15 DAYS":
...
AND (EXIT_DATE is null or EXIT_DATE < (SYSDATE - 15))
...
Unfortunately this variation causes an ORA-12054 error: "cannot set the ON COMMIT refresh attribute for the materialized view".
I would greatly appreciate any suggestion to overcome this problem.
Thank You very much.