| Imp: View a trigger history [message #38678] |
Mon, 06 May 2002 03:56  |
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  |
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 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
