[ACCEPTED]-How to check if a trigger is invalid?-triggers
Accepted answer
SELECT *
FROM ALL_OBJECTS
WHERE OBJECT_NAME = trigger_name
AND OBJECT_TYPE = 'TRIGGER'
AND STATUS <> 'VALID'
0
Have a look at SYS.OBJ$, specifically the 1 STATUS column.
Source:
stackoverflow.com
More Related questions
Cookie Warning
We use cookies to improve the performance of the site. By staying on our site, you agree to the terms of use of cookies.