Re: [Q] way to check table last modify time?

  • From: "Allan Nelson" <anelson77388@xxxxxxxxx>
  • To: mccdba1@xxxxxxxxx
  • Date: Wed, 25 Apr 2007 11:53:21 -0500

Only if your application maintains it as columns in the tables.  Most ERP
tables work this way.  You can also audit these actions on tables that you
are interested and see all the times there was insert, update, and delete
activity.

Allan

On 4/25/07, dba1 mcc <mccdba1@xxxxxxxxx> wrote:

Does there has way to check last time table be
modified (insert/update/delete)?  I checked dba_tables
and dba_objects and can NOT find it.

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
//www.freelists.org/webpage/oracle-l



Other related posts: