O'Reilly logo

Oracle GoldenGate 11g Implementer's guide by John P Jeffries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Configuring the Initial Load

An Initial Load synchronizes the source and target databases, which is an important first step in data replication. It extracts an entire copy of the source data set, transforms it if necessary, and applies it to the target tables. Data replication can now continue from this point.

One really cool feature is the ability for GoldenGate's "change synchronization" to keep track of ongoing transactional changes while the initial load is being applied. If configured, the Change Data Capture and Delivery concurrent process tracks the incremental changes, which are then reconciled with the results of the Initial Load.

So why is the Initial Load so important? To answer this question, consider an UPDATE statement. By its pure ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required