开发者

Materialized view with trigger?

开发者 https://www.devze.com 2023-02-11 14:09 出处:网络
Can i create trigger 开发者_StackOverflowon materialized view? I\'m using oracle 10g.Yes, you can. Just be careful. This is what Oracle documentation says:

Can i create trigger 开发者_StackOverflowon materialized view? I'm using oracle 10g.


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.

0

精彩评论

暂无评论...
验证码 换一张
取 消