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.