Getting the last data update time of all tables

Getting the last data update time of a specific table in Oracle

Last updated: 14 February 2018

Warning: Review and test in a non-production environment before running.

Back to results

select table_name,count(table_name) cnt,max(timestamp) timestamp
from user_tab_modifications
group by table_name
order by 1,2 desc,3 desc