Hi Everyone,

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?

Thanks
Peer