Poster: ORA-01732: data manipulation operation not legal on this view (4362233)

When a Materialized view is created in Oracle, by default, Oracle creates a base table for the corresponding Materialized view with the same name.

As of SharePlex version 8.6.6, with the Capture parameter SP_OCT_REPLICATE_MVIEW set to 1(default), SharePlex can only replicate DMLs from a Materialized view on Source to the Materialized view base table on the Target. 

Drop the Materialized view, leaving the base table intact for replication to work.

DROP MATERIALIZED VIEW <SCHEMA>.<MVIEW_NAME> PRESERVE TABLE;