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

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_at_yahoo.com> 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