Re: How to find out when an Oracle table was updated the last time in Oracle 8i?
From: Tim Gorman <tim_at_evdbt.com>
Date: Tue, 23 Apr 2013 21:27:34 -0600
Message-ID: <51775126.4040603_at_evdbt.com>
Ashoke,
Date: Tue, 23 Apr 2013 21:27:34 -0600
Message-ID: <51775126.4040603_at_evdbt.com>
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-lReceived on Wed Apr 24 2013 - 05:27:34 CEST