Column modification in Oracle with GoldenGate replication from oracle to postgres active
edited Jul 22, 2016 8:23PM in GoldenGate, Streams and Distributed Database (MOSC) 3 commentsAnswered ✓
All,
With GoldenGate for oracle to postgres active, how do we effect a modification of a column in Oracle DB (we add new column, update using old column and drop the old column for a reason) to replicate to postgres without data loss?
GoldenGate version :11.2.1.0.30
Oracle DB version : 11.2.0.4
Postgres Version: 9.4.8
We certainly can stop the extract and replicat. However the steps taken on the source of adding column, dropping old column need to be replayed on the postgres db? There could be multiple ddls. The ddl replication does not work between heterogenous replication.
The simplest approach is to initial load and then sync. However for large table(s) this approach is not the best.
0