title: the best way to track data changes in oracle
body: <p>as the title i am talking about, what's the best way to track data changes in oracle? i just want to know which row being updated/deleted/inserted?</p>
  
  <p>at first i think about the trigger, but i need to write more triggers on each table and then record down the rowid which effected into my change table, it's not good, then i search in Google, learn new concepts about materialized view log and change data capture,</p>
  
  <p>materialized view log is good for me that i can compare it to original table then i can get the different records， even the different of the fields, i think the way is the same with i create/copy new table from original (but i don't know what's different?); </p>
  
  <p>change data capture component is complicate for me :), so i don't want to waste my time to research it.</p>
  
  <p>anybody has the experience the best way to track data changes in oracle?</p>