My Oracle Support Banner

Using Oracle (x)Streams DML / Error Handlers For GoldenGate Integrated Replicat. (Doc ID 2721209.1)

Last updated on OCTOBER 28, 2020

Applies to:

Oracle GoldenGate - Version 12.3.0.1.0 and later
Oracle Database - Enterprise Edition - Version 18.0.0.0 and later
Information in this document applies to any platform.

Goal

Oracle Streams is the pre-GoldenGate integrated era of data replication among Oracle databases. Since GoldenGate has been integrated with the Oracle Database thru its processes called Integrated Extract (IE) and Integrated Replicat (IR), the same can take the advantage of using some of the Oracle (x)Streams components. One these components is the Oracle Streams DML / Error Handlers. Additionally to all the data transformation and conflict features that GoldenGate already carries, such as CDR (Conflict Detection & Resolution - RESOLVECONFLICT), REPERROR, and HANDLECOLLISIONS, we can configure a DML handler or Error Handler thru API DBMS_APPLY_ADM.SET_DML_HANDLER.
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.