Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Need to insert change_sequence as number of transaction happened on source in target.

Gokul M SApr 17 2025

we capture all transaction happened on source in our target staging, we need a sequence value inserted in replication target to understand sequence of operations happened on the source record. this would be new column in target let us call "change_sequence" which is not present in source.

Ex: table a source
col1(bk) col2
1 32

table a target
col1(bk) col2 change_sequence change_action
1 1 1 I

1 2 2 U

1 32 3 U

Comments
Post Details
Added on Apr 17 2025
0 comments
52 views