The Oracle (tm) Users' Co-Operative FAQ

Is there a way to get the Date/Time when a table was last updated ?


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 ?

Back to index of questions


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:


Back to top

Back to index of questions