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