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 trig