I think the reason why we can't update a materialized view directly is because it is basically a "view" and it should not contains any data irrelevant to its definition and underlying tables. If we would have a feature to update a materialized view direcly, maybe, it should behave as updatable-view as well as normal (virtual) views, although I am not sure....
Well, I didn´t find any place where is detailed why those tables are not updatable.
And would be fine to be updated through triggers or cron jobs until IVM is available.
CheckValidRowMarkRel just gives an exception "cannot lock rows in materialized view ...", but why ?
What are the differences between Materialized Views and tables ?
