Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: [Q] way to check table last modify time?
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-lReceived on Wed Apr 25 2007 - 11:53:21 CDT