My Oracle Support Banner

Example For GoldenGate Replication Setup For Materialized View (Doc ID 2452979.1)

Last updated on SEPTEMBER 28, 2018

Applies to:

Oracle GoldenGate - Version 12.2.0.1.0 and later
Information in this document applies to any platform.

Goal

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.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.