-
Auditing
Hello. I am new to Oracle. Using Oracle 9i on Windows 2000.
My question:
I need to audit a table and was wondering if someone could give me a trigger example. I need to copy all changes to table over to another table. ie. Copy deleted rows, inserted rows, updated rows, etc.
Let say that my table is called "money" and it has 3 columns(amount, type, color). I would like to copy all changes to "money_audit".
Thank you.
-
Check the docs. Basically, create a post-delete/insert/update trigger(s) on the table for each row that inserts into the audit table.
-
What have you tried so far? Post some code.