Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: [Q] way to check table last modify time?

Re: [Q] way to check table last modify time?

From: Allan Nelson <anelson77388_at_gmail.com>
Date: Wed, 25 Apr 2007 11:53:21 -0500
Message-ID: <ffb96860704250953l5e0c4a9cn547236d8574f5689@mail.gmail.com>


Only if your application maintains it as columns in the tables. Most ERP tables work this way. You can also audit these actions on tables that you are interested and see all the times there was insert, update, and delete activity.

Allan

On 4/25/07, dba1 mcc <mccdba1_at_yahoo.com> wrote:
>
> Does there has way to check last time table be
> modified (insert/update/delete)? I checked dba_tables
> and dba_objects and can NOT find it.
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Apr 25 2007 - 11:53:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US