How to find out Last Modification Time of a database? [message #664418] |
Mon, 17 July 2017 04:44 |
|
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.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|