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-06910: CMX: Cannot start oracle process on remote machine

1 Answers  


ORA-12583: TNS:no reader

1 Answers  


TNS-04204: Trace Assistant Internal ERROR: Couldn't Open trace file

1 Answers  


ORA-38748: cannot flashback data file string - file is in use or recovery

1 Answers  


ORA-02737: osnpcl: cannot tell orapop to exit

1 Answers  






ORA-19560: %s is not a valid device limit

1 Answers  


TNS-12225: TNS:destination host unreachable

1 Answers  


NNL-00416: Last timestamp: number

1 Answers  


PCC-02109: SQLCHECK=NONE is no longer supported.. using SYNTAX

1 Answers  


ORA-37014: (XSACQUIRE_ACQUIRED) Object workspace object is already acquired.

1 Answers  


TNS-04076: Invalid specification for state.

1 Answers  


PLS-00553: character set name is not recognized

1 Answers  


Categories