Thank you, for some reason I must have done something wrong, because it works now.

But do you know why the same MV with refresh on commit doesn't work on a view based 1:1 on that table? (Message: ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized view)

I'm working my way step-by-step towards solving an issue of which this seems to be one of several problems.

Bye
Peer