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:
You can also use Oracle Logminer for this task:
Dig Deeper on Oracle database design and architecture
Related Q&A from Don Burleson
Suppose you have a table which has only two columns, namely locid (not primary) and place. In Oracle, which query should I run to get the output as ... Continue Reading
I have created a table, Party, and in it there are two main fields, party_code and party_name, and around 2,500 records are available in it. I passed... Continue Reading
I have a query that retrieves around 10 records. I have a task to concatenate the values separated with ','. I would like to know if Oracle has any ... Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.