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-25241: cannot change correlation ID from string to string without FIRST_MESSAGE option

1 Answers  


ORA-28274: No ORACLE password attribute corresponding to user nickname exists.

1 Answers  


ORA-29804: missing DATA keyword

1 Answers  


ORA-13155: invalid number of dimensions specified

1 Answers  


ORA-01629: max # extents (string) reached saving undo for tablespace string

1 Answers  






IMG-00517: height or width not present in parameter string

1 Answers  


IMP-00079: Warning: National character set data in this table may be incorrect

1 Answers  


ORA-27543: Failed to cancel outstanding IPC request

1 Answers  


TNS-04144: Nothing to migrate

1 Answers  


ORA-22805: cannot insert NULL object into object tables or nested tables

1 Answers  


ORA-39136: cannot specify an SCN on a transportable job

1 Answers  


ORA-22800: invalid user-defined type

1 Answers  


Categories