基于视图建立的instead of trigger如果重建或drop视图则trigger会消失oracle文档提到INSTEAD OF triggers defined in the view are dropped when aview is re-created。要规避和解决此类问题需在开发工作中如果有视图的修改应该去检查是否关联存在INSTEAD OF triggers。 
长河君 · 2026/10/7 3:17:47 · 阅读 1.2k oracle基于视图的instead of trigger丢失
基于视图建立的instead of trigger如果重建或drop视图则trigger会消失oracle文档提到INSTEAD OF triggers defined in the view are dropped when aview is re-created。要规避和解决此类问题需在开发工作中如果有视图的修改应该去检查是否关联存在INSTEAD OF triggers。