This discussion is archived
1 Reply Latest reply: Mar 30, 2013 8:10 AM by Osama_Mustafa RSS

Query on Change Data Capture

user10547935 Newbie
Currently Being Moderated
Hi,


A small clarification on oracle CDC(change data capture),if the CDC is down for 6 hours due to some issues how do I capture all the source transactions into CDC views during this window?

Just doing a purge and restarting the CDC Subscriber would solve the above scenario?

Thanks
  • 1. Re: Query on Change Data Capture
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    Oracle CDC is all about capturing changes in DB tables and the changes are stored in special Oracle tables. There are two modes of CDC operation: asynchronous (based on Java) or synchronous (based on DB triggers, more performance overhead).

    Check
    http://docs.oracle.com/cd/B13789_01/server.101/b10736/cdc.htm#i1025409
    http://docs.oracle.com/cd/E14571_01/integrate.1111/e12643/data_capture.htm

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points