Login  Register

goldengate replication commit order capture

Posted by Harsha Vardhan on Sep 30, 2020; 9:22pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/goldengate-replication-commit-order-capture-tp8827.html

I have a table which is being replicated by goldengate to a table which captures all dml changes. Both source and target are oracle db.
Can we find out source commit order by looking at the following ?
1) transaction id
2) system change number
3) below expression recommended by oracle :

@COMPUTE(@COMPUTE(@NUMSTR(@GETENV('RECORD','FILESEQNO'))*100000000000)+@NUMSTR(@GETENV('RECORD','FILERBA')))