ansaurus

Question

Oracle 10g - Determine the date a Trigger was last updated

Answer 1

+3 A:

select object_name, object_type, created, timestamp
from user_objects
where object_name = 'nameOfYourTrigger'

The timestamp column will show the last touch.

dpbradley 2010-08-20 19:16:44

Thanks a lot buddy

danboh 2010-08-20 19:30:19

This may or may not be the last time someone made a *material* change to the trigger -- altering the table can invalidate that trigger, and Oracle will implicitly recompile that trigger on the table, which will update that timestamp.

Adam Musch 2010-08-20 20:19:55

@Adam - good point - the timestamp on the table should be evaluated in the context of this. Of course, the table timestamp will additionally change when grants are made on the table - one of my pet peeves.

dpbradley 2010-08-20 20:52:27

You could look at adding a trigger on DDL changes, recording various details from v$session (program, machine, etc). But I would presume only a very restricted number of people have the DBA access required to disable the triggers anyway.

JulesLt 2010-08-21 00:44:02

ansaurus

tags:

views:

answers:

Oracle 10g - Determine the date a Trigger was last updated

related questions