Re: a general 'Transactions in a database' question

You didn't mention what version of Oracle, but

1. In all versions of Oracle, you could use auditing to capture and audit trail. This will add some overvhead, and you may find it difficult to track a particular row. See http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/ a76965/c27audit.htm
2. In Oracle8i, Logminer gives you another offline capability you may suffice for what you are looking for. You can track who did 'what' to what rows - however, you won't actually see the what (i.e DML statments), just the affect they had. See http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/ a76956/archredo.htm#12680

> From: "sdenney" <sdenney_at_healthetech.com>
> Organization: TSCNET, Inc. (using Airnews.net!)
> Newsgroups: comp.databases.oracle.server
> Date: Fri, 2 Mar 2001 09:51:57 -0800
> Subject: a general 'Transactions in a database' question
>
> HI all,
>
> How does one keep track of all transactions made in a database? In other
> words, if I want to take a certain record and be able to browse back through
> what has been done with it and by whom, should I create transaction tables
> and triggers, or let Oracle handle it? I am looking for historical data,
> rather than just the ability to recover a database.
>
> Does anyone have experience? Does the question make sense?
>
> Thanks in advance,
>
> SD
>
>
Received on Sat Mar 03 2001 - 18:39:18 CST