Re: How to find out when an Oracle table was updated the last time in Oracle 8i?

From: David Fitzjarrell <oratune_at_yahoo.com>
Date: Wed, 24 Apr 2013 07:56:10 -0700 (PDT)
Message-ID: <1366815370.69458.YahooMailNeo_at_web121605.mail.ne1.yahoo.com>

If tables are monitored (which is available in 8i) you can also query DBA_TAB_MODIFICATIONS:  
set linesize 150
 
select table_owner, table_name, partition_name, subpartition_name, to_char(timestamp, 'DD-MM-YYYY HH24:MI:SS') last_mod from dba_tab_modifications
order by 3;
 
You can give this a try.
 
David Fitzjarrell

---

From: Tim Gorman <tim_at_evdbt.com>
To: oracle-l_at_freelists.org
Sent: Tuesday, April 23, 2013 9:27 PM
Subject: Re: How to find out when an Oracle table was updated the last time in Oracle 8i?

Ashoke,

DBMS_LOGMNR was available in Oracle8i;  you can mine the redo logs for that information.

Hope this helps...

-Tim

On 4/23/2013 3:54 PM, Mandal, Ashoke wrote:
> Hello All,
>
> Could you please tell me how to find out when an Oracle table was updated the last time in Oracle 8i. In Oracle 10g you could use the following query
> SQL> SELECT SCN_TO_TIMESTAMP(MAX(ora_rowscn)) from <table_name>;  but this doesn't work in Oracle 8i.
>
> Any help will be appreciated.
>
> Thanks,
> Ashoke

--
http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Apr 24 2013 - 16:56:10 CEST