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.

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

AlexLima-Oracle

The current support version of GoldenGate does not support Oracle 10.

You can ask Oracle Support if they have any options for you. Size and transaction rate might not be an issue, but you would need to POC.

OCI GG Service does not support Oracle 10.

I hope this helps.

Thanks

AL

1 - 1

Post Details

Added on Apr 28 2024
0 comments
113 views