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

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Wed, 24 Apr 2013 17:10:00 +0100
Message-ID: <CABe10sZMO7AuL=d1X+46MjJPTt_8a1FiRp+Dj5dPxczo-YnDew_at_mail.gmail.com>

That's a nice idea. It does have a couple of caveats though. First, the information is only flushed every few (I think 3) hours so it will only be an approximate measure, and second dba_tab_modifications includes transactions that rolled back. I imagine that actually what the original poster requires is auditing.

On Wed, Apr 24, 2013 at 3:56 PM, David Fitzjarrell <oratune_at_yahoo.com>wrote:

> 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
>
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info


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

Received on Wed Apr 24 2013 - 18:10:00 CEST