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-00476: RECO process terminated with error

1 Answers  


TNS-12663: Services required by client not available on the server

1 Answers  


TNS-00138: Failed to find ORACLE executable directory

1 Answers  


QSM-02086: mv uses the MIN or MAX aggregate functions

1 Answers  


ORA-30193: reserved for future use

1 Answers  






DRG-12013: This method has already been performed - repeat operation?

1 Answers  


ORA-21602: operation does not support the specified typecode

1 Answers  


DRG-50860: failed to prepare statement

1 Answers  


ORA-12322: unable to mount database (link name string)

1 Answers  


ORA-17506: I/O Error Simulation

1 Answers  


DRG-11724: phrase string already exists

1 Answers  


ORA-29400: data cartridge error string

1 Answers  


Categories