Q
Problem solve Get help with specific problems with your technologies, process and projects.

Capturing change in every column in every table

We have a scenario where I need to capture change in every column of every table in my database. Kindly suggest the pros and cons of the available alternatives, and the process of retrieving the old and new data when required as per the transactions are concerned.

We have a scenario where I need to capture change in every column of every table in my database. I am working with Oracle9i EE. Kindly suggest the pros and cons of the available alternatives, and the process of retrieving the old and new data when required as per the transactions are concerned. If a transaction T1 is made with data D1 for column C1 and for the same column if D1 is updated to D2 for transaction T2, then my requirement is I should see transaction T1 with D1 and also transaction T2 with D2. I have heard about Change data Capture, and versioning. I would like to know your inputs on this. Thanks in Advance
You need to look at Oracle auditing, which will record all changes to the specified tables. The downside is that it takes lots of disk space and may slow down your database. Arup Nanda and I have details in our Oracle fine-grained auditing book.

And here are free white papers:

http://www.oracle.com/technology/oramag/webcolumns/2003/techarticles/nanda_fga.html

http://dba-oracle.com/oracle_news/2005_3_31_free_white_paper_database_auditing.htm

You can also use Oracle Logminer for this task:

http://oracle.ittoolbox.com/documents/industry-articles/auditing-past-transactions-with-oracle-logminer-2452

http://www.praetoriate.com/oracle_tips_logminer.htm

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close