Check for disabled TRIGGERS

Check for disabled TRIGGERS

SELECT owner || '.' || trigger_name trigger_name, 

 table_owner || '.' || table_name table_name 

FROM dba_triggers 

WHERE status = 'DISABLED' 

ORDER BY owner, table_name;