On May 9, 8:48=A0am, alastair.coo...@[EMAIL PROTECTED]
wrote:
> 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
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
|
