[naujvi]

I want to know if there is anyway to know the date when a table have been updated in the
Oracle systems views.
Something like LAST_DDL_TIME (USER_OBJECTS) but of data (not structure), ¿¿LAST_DML_TIME??
Or something similar to LAST_ANALYZED but with data not statistics

Thanks in advance,

[LKBrwn_DBA]

If you have set your tables to "MONITORING", then check:

{ALL|DBA|USER}_TAB_MODIFICATIONS

SQL> desc ALL_TAB_MODIFICATIONS
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 TABLE_OWNER                                        VARCHAR2(30)
 TABLE_NAME                                         VARCHAR2(30)
 PARTITION_NAME                                     VARCHAR2(30)
 SUBPARTITION_NAME                                  VARCHAR2(30)
 INSERTS                                            NUMBER
 UPDATES                                            NUMBER
 DELETES                                            NUMBER
 TIMESTAMP                                          DATE
 TRUNCATED                                          VARCHAR2(3)
 DROP_SEGMENTS                                      NUMBER