-
Title
Why replication is not supported from a Materialized View (MV) on source to a Materialized View on target? -
Description
Why replication is not supported from a Materialized View (MV) on source to a Materialized View on target?
-
Cause
General information. -
Resolution
A Materialized View is a database object that is derived from other database object(s) also termed as base object(s). A Materialized View can exist on source or on target or both. However, the view is derived from the base object(s) which typically exist on the same database as the view itself. It does not make logical sense to replicate data from MV on source to MV on target. It is possible for a MV to be updatable and receive DML from other sources such as replication from a source SharePlex, but such updates will be lost the next time the MV on target is refreshed. Hence SharePlex does not support replication from a MV on source to a MV on target.
-
Additional Information
SharePlex manuals would specify which objects are supported for replication and which ones are not. The logic behind not supporting some of those objects is important as well and this article attempts to explain it.