How to check if a trigger is invalid?

Question

I am working on databases that are automatically generated by moving tables with some obscure tools. By the way, we need to track changes in the information in the table through some triggers. And, of course, it happens that some changes in the table structure violate some triggers, for example, deleting columns or changing their type.

So the question is: is there a way to request Oracle metadata to verify that some triggers are broken to send a report to support?

The trigger user provides all the triggers and reports whether they are enabled or not, but does not indicate whether they are all valid.

Answer 1

SELECT * FROM ALL_OBJECTS WHERE OBJECT_NAME = trigger_name AND OBJECT_TYPE = 'TRIGGER' AND STATUS <> 'VALID' 

Answer 2

Take a look at SYS.OBJ $, specifically the STATUS column.