OnlineTable Migration

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Online Table Migration using GoldenGate

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

I would like to demonstrate a case study of table partitioning and “online migration” in a OLTP system with “near Zero Downtime”.

In such cases, GoldenGate is the best tool to achieve this goal of an on-line migration.

1)  Find out dependant objects.

Read More »

Advertisements