Oracle 10g - Determine the date a Trigger was last updated
Is there a way you can determine the date when a trigger was updated? The reason why I ask is because a costumer complained about receiving some erros in our 开发者_StackOverflow中文版application, but when I went to look at the table, it had all triggers disabled.
select object_name, object_type, created, timestamp
from user_objects
where object_name = 'nameOfYourTrigger'
The timestamp column will show the last touch.
精彩评论