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.