Why compare/repair is not supported on a Materialized View on Source to a Materialized View on Target?
A Materialized View is a database object derived from another database object, commonly referred to as the base object.
While it is supported to replicate the contents of a Source Materialized View into a table on the Target, replicating into a Materialized View on the Target is not supported.
Any DML changes applied directly to a Target Materialized View, including those performed by a repair operation, would be overwritten the next time the Materialized View is refreshed. Therefore, modifying the contents of a Target Materialized View through DML is not a valid or sustainable approach.
For the same reason, the compare/repair functionality does not support Target Materialized Views.
