sql - Materialized view with trigger? -
can create trigger on materialized view? i'm using oracle 10g.
yes, can. careful. oracle documentation says:
if create trigger on base table of materialized view, must ensure trigger not fire during refresh of materialized view. during refresh, dbms_mview procedure i_am_a_refresh returns true.
Comments
Post a Comment