How to identify the records from all tables which were part of a single transaction at source within single commit
Last updated on JUNE 06, 2018
Applies to:Oracle GoldenGate - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
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.
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 hundreds of Community platforms