Al Programming
Free source code programming in C#, VB.Net, Java, SQL
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
Newer Post
Older Post
Home