Home » Other » Client Tools » Imp: View a trigger history
Imp: View a trigger history [message #38678] Mon, 06 May 2002 03:56 Go to next message
Maneesh Misra
Messages: 2
Registered: May 2002
Junior Member
HI..

Can anyone tell me how can i track, on which date, a trigger on a table was disabled/enabled?

Is their a common place where i can get the info regarding the status/lastmodified/run/..etc for a database object?

thanx in advance
Re: Imp: View a trigger history [message #38682 is a reply to message #38678] Mon, 06 May 2002 05:12 Go to previous messageGo to next message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
query dba_objects/all_objects and look at last_ddl_time to check lastmodified.

query dba_triggers/all_triggers to get status(enable/disable) of trigger.

as far as i know,last run time will not be stored in data dictionary.
Re: Imp: View a trigger history [message #38696 is a reply to message #38678] Mon, 06 May 2002 22:46 Go to previous message
Maneesh Misra
Messages: 2
Registered: May 2002
Junior Member
Thanx for the reply....
But u see my concern is to find out the date on which the trigger was last disabled.
Can i find this out as in dba_triggers/all_triggers it will show the last complied date..

Thanx in advance..
Maneesh
Previous Topic: Re: Update problem
Next Topic: Cursor with rownum - Urgent how to speed up
Goto Forum:
  


Current Time: Fri Mar 29 10:09:06 CDT 2024