Why replication is not supported from a Materialized View (MV) on source to a Materialized View on target?
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.
