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


Other related posts: