Re: Oracle Change Data Capture????

Hi,

> Has anyone got any experience in using the Oracle Change Data Capture
"tool"
> in a 9205 Database?

Interesting, no response on CDC!

That fits my theory, that CDC is a fantastic feature, but a win - loose constellation. (OLTP has overhead and responsibility; DW only profit without effort).

So the OLTP part rather inclines to accept alternative data capture mechanisms (mostly connected with much higher overhead) but under the responsibility of the DW group.

Of course my experience is not necessary representative!

This could change in - my opinion - with asynchron CDC based in redo log as the responsibility of the capture may be passed over along with the log file and the OLTP overhead will be minimised.

Regards

Jaromir D.B. Nemec

• Original Message ----- From: "Loughmiller, Greg" <greg.loughmiller_at_cingular.com> To: <oracle-l_at_freelists.org> Sent: Wednesday, January 12, 2005 2:52 PM Subject: Oracle Change Data Capture????

Hey folks,

Has anyone got any experience in using the Oracle Change Data Capture "tool" in a 9205 Database? This specific database in question is a highly transactional OLTP environment. And we have a reporting development team wanting to use the CDC tool on this specific database to extract "deltas" for the data warehouse (different RDBMS..)

We "researched" this middle of 2004, and tended to not agree with how Oracle implemented this due to the use of the JVM, the use of triggers, and how the data would need to be "purged" from the CDC tables. Thoughts? Suggestions? I'm sure this isn't a new problem to solve and am curious how others may have approached the topic as well..

Thanks in advance

Greg Loughmiller

--
http://www.freelists.org/webpage/oracle-l



--
http://www.freelists.org/webpage/oracle-l