How to find out Last Modification Time of a database? [message #664418] |
Mon, 17 July 2017 04:44 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/bf668ff3d85c0b06d2e0664af9c20e6a?s=64&d=mm&r=g) |
muniraj_tomar
Messages: 7 Registered: July 2017
|
Junior Member |
|
|
Hi all,
we are using below query to get Last Modification Time of a database
select MAX(TIMESTAMP) from ALL_TAB_MODIFICATIONS
But whenever we run this query the output is the same date when this query is executed even though that database is not modified on that date.
We need a QUERY to get the last modified date/time for an oracle database. Any help would be appreciated.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|