Oracle Error ORA-23500: cannot switch master for a multi-tier materialized view repgroup “string”.”string”

Oracle Error Message

ORA-23500: cannot switch master for a multi-tier materialized view repgroup “string”.”string”

Reason for the Error

An attempt was made to switch master for a materialized view repgroup when its parent repgroup is also a materialized view repgroup. This is not allowed.

Solution

Drop and recreate the materialized view repgroup based on a proper parent repgroup.