Home » Developer & Programmer » Warehouse Builder » What mechanism does Oracle use behind Synchronous change data capture (CDC)?
What mechanism does Oracle use behind Synchronous change data capture (CDC)? [message #153898] Wed, 04 January 2006 12:40 Go to next message
goldsmmi
Messages: 1
Registered: January 2006
Junior Member
What mechanism does Oracle use behind Synchronous change data capture (CDC)?

I am interested in implementing Synchronous change data capture (CDC) and have managed to get it to work as proof of concept but have no idea what mechanism Oracle uses to capture DML events. Can anyone help because it will help me to assess the risk of using CDC instead of writing bespoke triggers.

In the documentation
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14223/cdc.htm

It claims 'Triggers on the source database allow change data to be captured immediately' however I can see no such triggers on my source database - but CDC is working. Is there some sort of background or internal oracle process which detects when DML is issued and then populates the change tables???
Re: What mechanism does Oracle use behind Synchronous change data capture (CDC)? [message #154165 is a reply to message #153898] Fri, 06 January 2006 01:12 Go to previous messageGo to next message
Frank Naude
Messages: 4417
Registered: April 1998
Senior Member
CDC is based on Oracle Streams, which is based on Oracle Advanced Queuing (AQ).

Streams Manual: http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14229/toc.htm

AQ Manual: http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14257/toc.htm

Best regards.

Frank
Re: What mechanism does Oracle use behind Synchronous change data capture (CDC)? [message #210860 is a reply to message #153898] Fri, 22 December 2006 12:39 Go to previous message
ljennings
Messages: 1
Registered: December 2006
Junior Member
You say that CDC is working...
I'm running Oracle 10G 10.2.0.2.0
and CDC is not working encountering LOGMINER out-of-memory errors.
Can u share how your setup. querious..

Thanks

Laurence
Previous Topic: about date conversion
Next Topic: extract data from flat file into target table
Goto Forum:
  


Current Time: Wed Aug 20 22:17:38 CDT 2014

Total time taken to generate the page: 0.13661 seconds