I know this seems silly, but I'm doing something wrong with materialized views, and somehow I can't seem to figure it out, however much I go into the manuals:
I have a simple materialized view, and all I want it to do is refresh its values automatically whenever the underlying tables (or views, or whatever) are altered, so it reflects the changed data.
Somehow I can't get the refresh to work and I can only see the old data state.
I've tried refresh force, refresh fast, materialized view logs, and other stuff, but I must be missing something.
Can anyone help me please?
Click Here to Expand Forum to Full Width