Hello. I am new to Oracle. Using Oracle 9i on Windows 2000.
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".
Check the docs. Basically, create a post-delete/insert/update trigger(s) on the table for each row that inserts into the audit table.
Last edited by kris109; 01-23-2004 at 12:30 PM.
Remember the Golden Rule - He who has the gold makes the rules!
Ph.D., OCP 8i, 9i, 10g, 11g DBA
What have you tried so far? Post some code.
Click Here to Expand Forum to Full Width