4 Replies Latest reply: Nov 28, 2012 2:02 AM by Helios-GunesEROL RSS

    Last change for Database object

    927467
      Hello 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