CODEWITHSUNDEEP
sqloracle-databasetriggersoracle10g
Zeck
Zeck

Reputation: 6579

Materialized view with trigger?

Can i create trigger on materialized view? I'm using oracle 10g.

Upvotes: 2

Views: 5285

Answers (1)

Pablo Santa Cruz
Pablo Santa Cruz

Reputation: 181420

Yes, you can. Just be careful. This is what Oracle documentation says:

If you create a trigger on a base table of a materialized view, then you must ensure that the trigger does not fire during a refresh of the materialized view. During refresh, the DBMS_MVIEW procedure I_AM_A_REFRESH returns TRUE.

Upvotes: 6

Related Questions