This content has been marked as final. Show 3 replies
No, it's not safe to do so.
It was explained that Oracle does not guarantee how the changes are applied to the materialized view and in which order. Moreover the mechanism of the refresh could potentially change between releases. Also there were numerous bugs reported for the triggers created on MV container table.
If you have access to Oracle Metalink look for the article [ID 67424.1].
Edited by: Max Seleznev on Dec 10, 2012 2:32 PM