Thursday, January 3, 2013

How to find out when is the last time a particular table was updated

In order to find out when was a particular table updated last (in Oracle), use ORA_ROWSCN:
SELECT SCN_TO_TIMESTAMP(MAX(ORA_ROWSCN)) FROM TableName;

No comments:

Post a Comment