just a guess(as i've not tested it) but does last_ddl_time in
sys.dba_objects get updated when a trigger is enabled or disabled? I'm
short on time or i'd checked it out to see.
joe
Alroy Mascrenghe wrote:
>
> Hi All
>
> Is there a way of knowing when a database table/row
> level trigger was disabled...? Does Oracle keep any
> log..?
>
> Alroy
>
> ____________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
> or your free @yahoo.ie address at http://mail.yahoo.ie
> --
> Author: =?iso-8859-1?q?Alroy=20Mascrenghe?=
> INET: mark_alroy_at_yahoo.co.uk
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--
Joe Testa http://www.oracle-dba.com
Oracle 8i documentation online http://www.oracle-dba.com/oracle-docs
Received on Sun Jun 04 2000 - 09:10:54 CDT
