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!

MySQL to Oracle Identity columns

cptkirkshApr 28 2024

I am running GGMA 21.3 patched to april 2024. I am migrating from MySQL 8 to Oracle 19. In January I did a migration just fine and had no issues with the sequences on identity columns. I had to reinstall my GG instance on RHEL8 in a Hub configuration and when i do an Initial Load it copies all the data just fine except on tables where there is a identity column in MySQL it copies them but it gives me a lower number than the max of the column for the sequence and therefore it doesn't work properly. An y idea why that is? it sets the sequence for the number of rows in the table. Which is lower than the max(primary key). is there something i am doing wrong? Thanks in advance.

Comments
Post Details
Added on Apr 28 2024
0 comments
150 views