带有触发器的物化视图? [英] Materialized view with trigger?

问题描述

我可以在物化视图上创建触发器吗?我正在使用Oracle 10g.

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

推荐答案

是的，可以.请注意.这就是 Oracle文档所说的:

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

如果在基础上创建触发器 实例化视图的表，然后您 必须确保触发器不 在刷新期间开火 物化视图.在刷新期间， DBMS_MVIEW过程I_AM_A_REFRESH 返回TRUE.

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.

这篇关于带有触发器的物化视图?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！