DBA Hub

📋Steps in this guide1/1

Last modified table

Sometimes Application team might asked you to provide details of last modified table in oracle. So just run the below query :

oracle configurationintermediate
by OracleDba
12 views
1

Overview

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
set linesize 500;
select TABLE_OWNER, TABLE_NAME, INSERTS, UPDATES, DELETES, 
to_char(TIMESTAMP,'YYYY-MON-DD HH24:MI:SS')
from all_tab_modifications
where table_owner<>'SYS' and
EXTRACT(YEAR FROM TO_DATE(TIMESTAMP, 'DD-MON-RR')) > 2010
order by 6;

Comments (0)

Please to add comments

No comments yet. Be the first to comment!