All Forums Database
barani_sachin 141 posts Joined 01/12
04 Mar 2012
Identifying when the last update or insert was done on a particular table...

how to identify when the last update or insert was done on a particular table... is there a way??

ulrich 816 posts Joined 09/09
04 Mar 2012

In general - no.

Usually it is good habit to maintain this info in some meta data columns / tables during the ETL process.

LastAccessTimestamp from dbc.tables will not help you as it covers also selects.

If all queryies of users which are able to do updates and inserts on the tables in question are logged via DBQL you can search there for Update or Inserts. 

feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud

barani_sachin 141 posts Joined 01/12
05 Mar 2012

What about the LastAlterTimeStamp?? Will it consider only insert and update or select also??           

ulrich 816 posts Joined 09/09
05 Mar 2012

from the manual

 

LastAlterTimeStamp Returns the time the Data Dictionary row was last updated.

 

 

This will be done if the table itself will be changed for example with an alter table statement. 

So no - will not help

feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud

barani_sachin 141 posts Joined 01/12
05 Mar 2012

Ohkk... Thanks for u r timely replies :)

You must sign in to leave a comment.