I’m not a DBA but have recently learned how to highlight incremental changes in imported data in TDP.
I made it all the way through the Data Compare wizard to create the UPDATE & INSERT scripts to synch the TARGET table but,
I am looking for help to do the following …
- Run the script and add/update the new records
- Log the changes in a new CHANGE table with the following fields
- Record ID
- Table Name
- Field Name
- Old Value
- New Value
- Change Date
I’m running Oracle and was reading about the FGA (Fine Grain Auditing) policy to log changes (add/change/delete) on specific object schemas / names in another table. Not sure I’m able / qualified to set up “packages”, but any help would be greatly appreciated!
Thanks in advance!