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



ORA-23500: cannot switch master for a multi-tier materialized view repgroup "string".&quo..

Answer / guest

Cause: 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.

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

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-33008: (XSAGDNGL03) The relation workspace object is not a relation over a base dimension of AGGMAP workspace object.

1 Answers  


NID-00451: Succesfully changed database name.

1 Answers  


ORA-12521: TNS:listener does not currently know of instance requested in connect descriptor

1 Answers  


ORA-12494: cannot insert or delete a level, category, or release category

1 Answers  


RMAN-06435: recovery catalog owner is string

1 Answers  






ORA-28538: result set not found

1 Answers  


PLS-00711: PRAGMA AUTONOMOUS_TRANSACTION cannot be declared twice

1 Answers  


ORA-19010: Cannot insert XML fragments

1 Answers  


ORA-32510: cannot create watchpoint on unreadable memory

1 Answers  


ORA-19001: Invalid storage option specified

1 Answers  


PLS-01463: STDDEV is not a standard set function

1 Answers  


ORA-38770: FLASHBACK DATABASE failed during recovery.

1 Answers  


Categories