| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Change Data Capture (CDC) Feature
Joe,
We've been using CDC for several months on 9iR2. It works pretty well for us. It did take some study to figure it out and set it up, but it's fairly straightforward once one understands the general concepts. We haven't run into any pitfalls yet.
The Oracle 9i Data Warehousing Guide Chapter 15 contains detailed instructions for setting it up and using it:
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96520/cdc.htm#1656
Barbara
Joe Cooper wrote:
> One of our developers is looking for a better way to propagate nightly updates across several production and development instances. She came across a couple of white papers on a 9i (and beyond) feature called "Change Data Capture" (CDC). I personally haven't had the pleasure of meeting Ms. CDC (or is it Mr. CDC??) Has anyone had any real world experience with this animal?? How easy/difficult is it to setup and maintain? Any pitfalls -- documented or otherwise?? I'm quite intrigued with what I'm reading, but the source is OTN. For all I know, it could be that I'm being sold a big, juicy lemon by Uncle Larry's crew at Oracle central.
>
> Thanks in advance for any insights,
>
> Joe Cooper
> Senior Oracle DBA
> HIGHLINE Bank Data Services
> (A division of HIGHLINE Media)
> (formerly a division of Sheshunoff Information Services)
> (you gotta love mergers and acquisitions!!!)
> Austin, TX
>
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Mon May 17 2004 - 16:29:16 CDT
 |
 |