Ermittlung ungültige Trigger

Ermittelt Trigger die Invalid oder Disabled sind und sich im Schema EDV befinden

create view v_trigger_errors as 
select a.owner, a.trigger_name, a.status enabled, b.status
from all_triggers a, all_objects b
where a.owner        = 'EDV'
  and a.OWNER        = b.owner   
  and a.TRIGGER_NAME = b.OBJECT_NAME
  and 'TRIGGER'      = b.OBJECT_TYPE
  and (a.status = 'DISABLED' or b.status = 'INVALID');