Check Last Insert Update Merge Time Data Manipulation Language Operation Time for each row of a table
How to check Last Insert Update Merge Time i.e. Data Manipulation Language Operation Time for each row of a table. The application table does not have a audit column for timestamp and application code cannot be changed due to absence of budget and time.
The requirement is to find out the last insert update timestamp for each row of table. Auditing of DML operation on the table cannot be enabled due to performance overhead. Also new column on the table cannot be added to track last update and insert timestamp. Crawl the archive log files using logminer cannot be done as developers are not used to the tool...Read More