ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Tips--Metalink关于CDC的相关同步方式及对Oracle版本的要求(转)

Tips--Metalink关于CDC的相关同步方式及对Oracle版本的要求(转)

原创 Linux操作系统 作者:vongates 时间:2019-04-22 08:00:07 0 删除 编辑
Does Synchronous Change Data Capture use Log Miner Sessions?
Doc ID: Note:307088.1Type: HOWTO
Last Revision Date: 20-SEP-2006Status: MODERATED

Synchronous CDC does not use LogMiner sessions in any version of Oracle and is in fact trigger based.

Asynchronous CDC, which was introduced in 10.1, does use LogMiner sessions to capture changes because it utilises Streams technology.

However, the the 10.1 CDC asynchronous options (Asynchronous HotLog Publishing and Asynchronous AutoLog Publishing) cannot involve a 9.2 database.

Only with the introduction of 10.2 can you have a 9.2 database involved in a Asynchronous Distributed HotLog Publishing setup. In this setup the 9.2 database does not contain the change sets but a Capture process is used in the 9.2 database to capture changes on the source tables so implicitly a logminer session is being used

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29987/viewspace-52024/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2018-09-11

  • 博文量
    449
  • 访问量
    292707