Yes it definitely does. I checked it myself. Thanks.
This will be pretty helpful.
But does oracle maintain a history..i.e. during this
time this trigger was disabled but later it was
enabled..?
Alroy
- Rachel Carmichael <carmichr_at_hotmail.com> wrote: >
it probably does.... since it gets updated when you
> grant a priv to
> someone... that I DO know for a fact since it
> screwed me up when I was
> setting up some security checks to see who was
> modifying objects in my
> database.
>
>
> >From: "Joseph S. Testa" <teci_at_oracle-dba.com>
> >Reply-To: ORACLE-L_at_fatcity.com
> >To: Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
> >Subject: Re: Enbling and Diabling Table Triggers
> >Date: Sun, 04 Jun 2000 07:24:03 -0800
> >
> >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
> >--
> >Author: Joseph S. Testa
> > INET: teci_at_oracle-dba.com
> >
> >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).
>
>
> Get Your Private, Free E-mail from MSN Hotmail at
> http://www.hotmail.com
>
> --
> Author: Rachel Carmichael
> INET: carmichr_at_hotmail.com
>
> 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).
Do You Yahoo!?
Received on Mon Jun 05 2000 - 03:59:33 CDT
