Question related to TRIGGER on read only Materialized views
We have a Read Only Materialized view created on a pre-built table. The Materialized view is refreshed via FAST refresh option.
We have a row level trigger defined on the above pre-built table. However, this trigger DOES NOT alter the content of the Materialized View base table (Pre-built) itself.
The trigger populates/maintains another TABLE in the schema as the Read ONLY Materialized view. We have been having this set up and is running on Oracle 9i and Oracle 10g as well. We are in the process of upgrading the database to 11g. Hence we would like to check if you foresee any issues continuing with the above set up.