How to find the last modified date of a table in oracle

 How to find the last modified date of a table in oracle

In this post , We will be discuss about  How to find the last modified date of a table in oracle. We will be share the sample sql query which helps to find the last modified date of a table in oracle. We can find that , when the last change happened for a table in oracle. This helps to keep track on the latest changes for DB Tables. This is one of useful sql query for any DB Administrator. Here below is the detail about  How to find the last modified date of a table in oracle.

How to find the last modified date of a table in oracle

2 Important Table to find the last modified date of a table in oracle

1. ALL_OBJECTS
2.ALL_TABLES

Detail SQL Query to find the last modified date of a table in oracle

select tab.owner as table_schema,

       tab.table_name,

       obj.last_ddl_time as last_modify

from all_tables tab,

all_objects obj

Where tab.owner = obj.owner

and tab.table_name = obj.object_name

and tab.owner ='SYS'

and obj.last_ddl_time > (current_date - INTERVAL '60' DAY)

order by last_modify desc;

 How to find the last modified date of a table in oracle