Migration of table from MySQL to Oracle using GoldenGate
2
votes
1
answer
1109
views
I have a table of size 120 GB in MySQL 5.7 which I need to migrate to Oracle 12c. I am using Oracle GoldenGate for initial load of the table.
I tried with initial load of full table but it consumed complete RAM and I had to cancel it.
Even trying to run with primary key range initial load for 1/20th of table at a time, but it abends after certain time with:
> ERROR OGG-01233 Send TCP params error: TCP/IP error 110 (Connection timed out)
Is there any better approach to get this completed?
Asked by samir sahu
(21 rep)
Jul 30, 2018, 09:50 PM
Last activity: Jul 31, 2018, 02:52 PM
Last activity: Jul 31, 2018, 02:52 PM