GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Split tables from one Replicat to another replicat.

edited Mar 5, 2020 4:02AM in GoldenGate, Streams and Distributed Database (MOSC) 7 commentsAnswered

Currently there is one replicat processing many tables and I want to split that replicat into two new groups and transfer the tables from the old replicat to two new replicats.

I tested the process using the sample extract, pump and replicat. The problem is when i switch to a new replicat, the new replicat is applying the same changes again which was already processed by the old replicat.

Below is the example.

GG Version 12.1.2.1.10

1. Stopped the extract and pump process.

once the extract was stopped, waited for the Pump to catch up before stopping it.

once the pump is stopped, waited for the Replicat to catch up before stopping it.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center