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 and later
Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


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.


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

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