Re: How to find out when an Oracle table was updated the last time in Oracle 8i?
- From: David Fitzjarrell <oratune@xxxxxxxxx>
- To: "tim@xxxxxxxxx" <tim@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 24 Apr 2013 07:56:10 -0700 (PDT)
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@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
