For a materialized view which is in manual refresh mode, what is the best approach to use REFRESH MATERIALIZED VIEW from inside a trigger.
REFRESH MATERIALIZED VIEW will commit the data, which for me broke the overall logic.
So how to overcome this limitation and still refresh the view triggered by a trigger.
Immediate refresh mode is not possible to use, because my materialized view has no unique index column.
Put the refresh in an EVENT and use TRIGGER EVENT in the trigger.
answered 22 Mar '12, 09:22