Track table data changes (inserts, updates, deletes) including os_user
Leo_YMar 12 2013 — edited Mar 12 2013Hi ,
I was given a task by manager to keep track of changes on a given table including os_user who made it.
Should I create a trigger on it (on any update, insert, delete etc.) or there is a better way of doing it ?
I think there could be some info already in some data dictionary views or something like it.
If I CREATE MATERIALIZED VIEW LOG on that table would it help?
I'm kind of new to that sort of tasks,
Thanks a lot!