| Author's name: Author's Email:SPrabhu1@CHN.COGNIZANT.COM |
Date written: 7th May 2002 Oracle version(s): all |
| Is there a way to get the Date/Time when a table was last updated ? | |
One option is as follows:
(1) Turn the auditing on: AUDIT_TRAIL = true in init.ora
(2) Restart the instance if its running.
(3) Audit the table:
AUDIT INSERT,SELECT,DELETE,UPDATE on TableName by ACCESS WHENEVER SUCCESSFUL
(4) Get the desired information using :
SELECT OBJ_NAME,ACTION_NAME ,to_char(timestamp,'dd/mm/yyyy , HH:MM:SS') from sys.dba_audit_object.
Further reading: