ANKUSH THAVALI
- 08 Sep, 2023
- 0 Comments
- 20 Secs Read
Last modified table
Last modified table
Sometimes Application team might asked you to provide details of last modified table in oracle. So just run the below query :
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;