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@xxxxxxxxx> 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 -- //www.freelists.org/webpage/oracle-l