Search This Blog

Tuesday, April 29, 2014

Find last modified tables Oracle

Oracle > Scripts

USER_TAB_MODIFICATIONS describes modifications to tables owned by the current user that have been modified since the last time statistics.

Example: Find last modified tables:

select * from USER_TAB_MODIFICATIONS order by timestamp desc