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"
--
http://www.freelists.org/webpage/oracle-l
- References:
- [Q] way to check table last modify time?
- From: dba1 mcc
Other related posts:
- » Re: [Q] way to check table last modify time?
- » Re: [Q] way to check table last modify time?
- » Re: [Q] way to check table last modify time?
- » Re: [Q] way to check table last modify time?
- » Re: [Q] way to check table last modify time?
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.
- [Q] way to check table last modify time?
- From: dba1 mcc