Commit SCN in Oracle XStream events

[Andrejs Jermakovics]

Hi all

I was wondering why the events coming from XStream do not have a "commit_scn". Any reason why it is not populated?

It looks like the "scn" field is populated using XStreamUtility.getSCNFromPosition and there is a XStreamUtility.getCommitSCNFromPosition that could used for commit_scn.

Many thanks,

Andrejs

[Chris Cranford]

Hi -

With XStream, the LCR does not contain the Commit SCN, which is why the value is absent.

Thanks,
-cc

--
You received this message because you are subscribed to the Google Groups "debezium" group.
To unsubscribe from this group and stop receiving emails from it, send an email to debezium+u...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/debezium/5ef3d552-014c-4a8d-b267-7a90b73152d9n%40googlegroups.com.

[Andrejs Jermakovics]

Thank you for the quick reply! 

Not sure if it is related to our setup but we seem to have a Commit SCN in our LCRs (Oracle 19 and 23).

XStreamUtility.getCommitSCNFromPosition gave me an SCN that was larger than normal SCN and worked in flashback queries. 

[Chris Cranford]

Hi -

I was looking at RowLCR and didn't think to look at the utility class. In that case, could you raise a Jira enhancement request.

Thanks,
-cc

To view this discussion visit https://groups.google.com/d/msgid/debezium/92b659b3-6bd0-4636-b54c-9c859347553dn%40googlegroups.com.

[Andrejs Jermakovics]

Raised DBZ-9497