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

NZE-29020: The handshake record length is too long.

1 Answers  


NNL-00253: Server-generated requests currently request forwarding

1 Answers  


ORA-27216: skgfgsmcs: sbtinfo2 returned a malformed response

1 Answers  


ORA-23318: a ddl failure has occurred

1 Answers  


ORA-04054: database link string does not exist

1 Answers  






PLS-00625: PARTITION/CLUSTER/ORDER-BY clause can only be used with IN parameters

1 Answers  


LCD-00215: parameter files nested too deep [string]

1 Answers  


ORA-22810: cannot modify object attributes with REF dereferencing

1 Answers  


NNL-00916: Modification requests enabled: string

1 Answers  


ORA-06780: TLI Driver: recv error code failed

1 Answers  


AMD-00129: dimension #string: RDBMS GID column not specified

1 Answers  


ORA-13628: Insufficient privileges to access the task belonging to user string

1 Answers  


Categories