DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Auditing

  1. #1
    Join Date
    Jan 2004

    Question 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.

  2. #2
    Join Date
    May 2001
    San Francisco, California
    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 01:30 PM.
    Remember the Golden Rule - He who has the gold makes the rules!
    Ph.D., OCP 8i, 9i, 10g, 11g DBA

  3. #3
    Join Date
    Aug 2002
    Colorado Springs
    What have you tried so far? Post some code.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width