Date / Time a table was updated

[alastai...@googlemail.com]

Hi

We are running Oracle 9i on unix, is it possible to query the database
to find out the last date and time a named table has some data
updated / inserted

Thanks

Alastair

[ora...@msn.com]

Certainly there is, although if you've not set table monitoring on you
won't find anything. The view in question is DBA_TAB_MODIFICATIONS,
and it's used, in one aspect, by Oracle to determine if statistics on
a given table are STALE or not. You would probably want the following
information:

set linesize 132

select table_owner, table_name, to_char(timestamp, 'DD-MON-YYYY
HH24:MI:SS') chg_time
from dba_tab_modifications;

Again, if your tables aren't altered for monitoring you'll get
absolutely nothing from this view.

David Fitzjarrell