Commit Cycle ID (&CCID)

An identifier for the transaction with the insert, delete or update operation.

Data Type
Integer
Restrictions and limitations:
  • Support for this journal control field is available only when CDC Replication mirrors data, and is not available when refreshing data. If you decide to use this journal control field when refreshing data, CDC Replication sets this journal control field to a default value of 0.
  • CDC Replication Engine for Oracle XStream: Data for this journal control field is obtained from DefaultRowLCR.getTransactionId(). TransactionId data is extracted as a string from DefaultRowLCR. A sample of transactionid is 9.8.1457. When the transactionid string follows this pattern, CDC Replication splits it into three components based on dot and treats the first component as two bytes, second component as two bytes and third component as four bytes of a signed eight-byte-long number. If the format is different or parsing numbers from the string fails, the hashCode of the string is supplied as the value of CCID.