Oracle 11g: Using flashback to determine last time table row was updated
Using Oracle 11g I have been tasked with automating the removal of data based on whether it has changed in a certain time period. None of these tables currently have a column that indicates the last time they were updated. There are 5 tables in question. The obvious answer to this problem would be to add a date_updated column and bind it to a before insert or update trigger to add the date to replicate what is possible in MySQL. However, I was reading about flashback and was wondering if it could be used in some way to determine the last time a specific row within a table was last updated. The Oracle 11g documentation seems to hint that it is possible to retrieve the last time a row was updated but seems to lack any examples of what the implementation would be. I understand that generally speaking this is not the purpose of flashback but call me curious.