Example For GoldenGate Replication Setup For Materialized View
(Doc ID 2452979.1)
Last updated on SEPTEMBER 28, 2018
Applies to:Oracle GoldenGate - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
How to setup Goldengate for Materialized View?
Note: This example is only a demonstration on how you can setup replication for MViews. Please modify/configure as per your requirement.
In this example, Source database is ORCL and Target database ORCL1 and two separate GG homes, but extract and replicat are using same location for trail files, hence no extract pump is used here. DDL replication is enabled via GG.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!