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