Question:
We have a scenario where I need
to capture change in every column of every table in
my database. The process of retrieving the old and
new data as and when required as per the
transactions are concerned. I have heard about
Change data Capture, and versioning.
Answer:
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:
http://www.rampant-books.com/book_2003_2_audit.htm
And here are free whitepapers:
http://Remote DBA-oracle.com/oracle_news/2005_3_31_free_white_paper_database_auditing.htm
You can also use Oracle Logminer for this task:
http://www.praetoriate.com/oracle_tips_logminer.htm |