Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: How can I check the time when any table is updated under a

Re: How can I check the time when any table is updated under a

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Tue, 23 Jul 2002 11:23:31 -0800
Message-ID: <F001.0049FEA5.20020723112331@fatcity.com>


Ashoke,
 Any programer worth their salt should know what tables or objects are modified by their applications. They documented and wrote it and should know what happens when an "update, delete, insert, etc" happens to the data. If they do not know what happens, How did they write the application?.
 If it is an inherited application and the documentation is not available, that is a different story. Then you will have to use auditing or the "trigger to table" method.

I know that I sound harsh in my statements but in the old school that's how we had to work, documentation, test, documentation.... I have found in today's programming world that to many times it is easier to cut and paste code to get the project running and not even do the documentation.
PS( I retired from an ISO9001/2 company) ROR mm

>>> wisernet100_at_yahoo.com 07/23/02 02:33PM >>> none of them will capture DML changes

you have two choices:

  1. turn on auditing... this will tell you at a macro level what has been touched, but won't necessarily tell you who did it or if it was done by the execution of his app
  2. add an update_dt and an updated_by column to all tables and create a trigger which fires on insert/update/delete to fill the column of the row with sysdate and the userid of the user. This is very detailed, down to the row level but may also not give you whether or not the change was made during the execution of his application
    • "Mandal, Ashoke" <ashoke.k.mandal_at_medtronic.com> wrote:
      > Hi,
      >
      > One of my developer wants to know what are the tables or any other
      > objects being modified during the execution of his application.
      >
      > dba_objects have following 3 date fields. But I am not sure if any
      of
      > these date fields will capture the last DML(update, insert or
      delete)
      > time.
      >
      > CREATED
      > LAST_DDL_TIME
      > TIMESTAMP
      >
      > Any idea?
      >
      > Thanks in advance,
      > Ashoke
      >
      > --
      > Please see the official ORACLE-L FAQ: http://www.orafaq.com
      > --
      > Author: Mandal, Ashoke
      > INET: ashoke.k.mandal_at_medtronic.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!?
Yahoo! Health - Feel better, live better http://health.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Rachel Carmichael
  INET: wisernet100_at_yahoo.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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ron Rogers
  INET: RROGERS_at_galottery.org

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).
Received on Tue Jul 23 2002 - 14:23:31 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US