Are there any Oracle tables which keep track of when a table was last updated via a DML statement?
I would love a select like
select table_name from user_tables
where last_dml_update_done > sysdate - 5.
I don't want to use auditing, and was just wondering if there are any internal Oracle tables that keep track of this.
I do have SYS_UPDATE_TIME on most of my tables, which does give me what I want. But it's the tables which don't have this column that I'm trying to work on.
Bookmarks