Last change for Database object
927467Nov 28 2012 — edited Nov 28 2012Hello All,
I've a requirement to find out if a table has been changed or not, is there any data dictionary reference which can tell me when the table has last touched(update,delete,insert) ?
max ora_rowscn can be used to compare if a table has changed or not.. but i've a concerns
1. if all the rows except the one associated with max ora_rowscn are deleted , then i'd still treat the table as not modified
Im trying to use dba_tab_modifications, but that doesnt seem to be getting updated.. saying when the table was last modified.
Any pointers are appreciated. thanks