Re: What causes a trigger to become disabled?

smontgomerie_at_hotmail.com (Steve) wrote in message news:<156709aa.0211211042.78ae7a81_at_posting.google.com>...
> Hello,
> How is it possible for a trigger to appear as disabled (in
> user_triggers) without explicity issuing ALTER TRIGGER ..DISABLE?
>
> We exported the db to a client site, checked for invalid objects
> (there were none) and now a week later mysteriously proceses have
> stopped working which we have found is related to triggers being
> disabled.
>
> Here's what I checked.
> >Ran a simple testcase with a trigger that inserts values into
> specific columns of a table. Dropped one of the columns that the
> trigger inserts into. The trigger shows as invalid but is still
> enabled
> >Droped a table that the trigger inserts into. The trigger shows as
> invalid but is still enabled.
>
> I also thought that perhaps the trigger may not have got enabled on
> import however these processes have been working fine since the import
> until just the past day. The import occured over a week ago.
>
> We are 90140 on win 2k
>
> tks for any suggestion

Get the last_ddl_time from all_objects where object_type = 'TRIGGER' and object_name = <trigger_name> That will give you when it was that the trigger was disabled (assuming it is still disabled). Also you could query all_source to see if there is an 'alter trigger' statement in there somewhere.
Are there any synonyms on the triggers? Are there any other objects with the same name as the triggers?

• rajXesh