Oracle Change Tables – An Example

Here is an example of how to create and use Oracle Change tables. This is part of what Oracle refers to as “change data capture” or CDC.

Oracle change tables allow you to capture what has changed in a specific table over a period of time. This can be useful if you are attempting to keep data updated with a source. Typically CDC is used as part of the “extract” process in an extract-transform-load procedure for loading a data warehouse.

There are many sties and articles on this topic that go into much more depth than I will here, however I have never found a fully functional demonstration of an entire CDC cycle.

Change table example code

For more information on change data capture I recommend Oracle’s Data Warehousing Guide. More on data warehousing in general can be found at Mark Rittman’s Oracle Weblog.

A new feature in Oracle 10g called ‘streams’ offers an alternative to this type of CDC, however I (and I’m sure many others) are still dealing with change tables on a regular basis.

Technorati tags: , , , , , ,

3 thoughts on “Oracle Change Tables – An Example”

  1. Thanks. Spelling was never my strong point (and a career in the world of acronyms hasn’t helped.) It’s corrected in the article title although the link may not show it correctly.

  2. I found the information, I was looking for. Thank You Very Much.
    The Websitname and Quotation is interesting. I would think of something like “Life with Coffee., because I don’t believe in life without it.


Leave a Reply

Your email address will not be published. Required fields are marked *