Re: Last Update

From: Shreepad Vaidya <Shreepad.Vaidya_at_alltel.com>
Date: Mon, 16 Jul 2001 02:22:40 -0700
Message-ID: <F001.0034AB11.20010716020558@fatcity.com>

Hi Erik,

Check out the dba_objects tables.
There is a column called as Last_ddl_time , which will give the ddl time. But if you want to capture select,insert,delete,update times ?
I guess you will have to write trigger and capture the times.

HTH

                    shreepad


                    shreepad




To:   Shreepad Vaidya/EMEA/ALLTELCORP, ORACLE-L_at_fatcity.com AT
      INTERNET_at_CCMAIL

cc:

How can I tell when a table was last updated? I am able to tell when it is
last anylized, but I am looking for the date of the last DML on the table.

Thanks
Erik

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Erik Williams
  INET: ewilliams_at_brownco.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: Shreepad Vaidya
  INET: Shreepad.Vaidya_at_alltel.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).

Received on Mon Jul 16 2001 - 04:22:40 CDT