Invalid Triggers
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Invalid Triggers as PDF for free.
More details
- Words: 43
- Pages: 1
select distinct 'alter ' || a.type || ' '|| a.owner || '.' || a.name || ' compile;' from dba_dependencies a, dba_objects b where a.name=b.object_name and (a.owner='lambent' and a.referenced_name ='tr_gin_recp_detail') and b.status='invalid'; the invalid triggers tr_gin_detail_del_upd_new tr_gin_detail_del_upd_trig tr_gin_detail_insert_trig
drop trigger tr_gin_detail_del_upd_new drop trigger tr_gin_detail_del_upd_trig
drop trigger tr_gin_detail_del_upd_new drop trigger tr_gin_detail_del_upd_trig
Related Documents
Invalid Triggers
October 2019 16
Triggers
May 2020 15
Triggers
November 2019 38
Triggers
June 2020 12
Triggers
May 2020 17