How to find last modified table in oracle.

Here is the query below.

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;

 

Recent Posts