migrating a legacy application in which the trigger ran on actual tables but that became extremely hard to accomplish with the modified database structure so i thought of
using an mview to act as the trigger's base table.
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