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

  • From: "Alberto Dell'Era" <alberto.dellera@xxxxxxxxx>
  • To: mccdba1@xxxxxxxxx
  • Date: Wed, 25 Apr 2007 19:08:34 +0200

Maybe dba_tab_modifications is what you are looking for ?

The "timestamp" column is approximated, and the view
itself may be updated only after some hours (at least in 9.2),
but it may be adequate.

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.



--
Alberto Dell'Era
"dulce bellum inexpertis"
--
//www.freelists.org/webpage/oracle-l


Other related posts: