My Oracle Support Banner

How to identify the records from all tables which were part of a single transaction at source within single commit (Doc ID 2407462.1)

Last updated on JUNE 06, 2018

Applies to:

Oracle GoldenGate - Version 12.1.2.0.0 and later
Information in this document applies to any platform.

Goal

Using Oracle GoldenGate to replicate/CDC from source Oracle DB to target Oracle DB.

How to know which records were part of a single commit at source when we replicate the data to target DB so that our downstream systems work on basis of the source DB commit point and process the records.

For example, in OGG terms the CSN(Commit Sequence Number) is equal to the Oracle SCN. So if I issue 5 Inserts within a single commit (total 5 tables, 1 insert per table) then all the 5 records should have the same SCN number as I will be loading the SCN values of all records in target table for our downstream system to pick all 5 records as part of that SCN and process them.
 

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!


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