Oracle Error ORA-12046: cannot use trusted constraints for refreshing remote MV

Oracle Error Message

ORA-12046: cannot use trusted constraints for refreshing remote MV

Reason for the Error

REFRESH USING TRUSTED CONSTRAINTS specified in ALTER MATERIALIZED VIEW or CREATE MATERIALIZED VIEW of a remote materialized view

Solution

remove this attribute from ALTER/ CREATE MATERIALIZED VIEW DDL