QSM-02021: set operator encountered in mv



QSM-02021: set operator encountered in mv..

Answer / guest

Cause: The capability in question is not supported when the
materialized view uses set operators such as UNION, UNION
ALL, MINUS, etc.

Action: Re-phrase the query to avoid the use of set operators.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

RMAN-08126: keep attributes for the proxy copy are changed

1 Answers  


ORA-31650: timeout waiting for master process response

1 Answers  


ORA-28651: Primary index on IOTs can not be marked unusable

1 Answers  


ORA-23534: missing column in materialized view container table "string"."string"

1 Answers  


ORA-16550: truncated result

1 Answers  






ORA-15059: invalid device type for ASM disk

1 Answers  


ORA-01042: detaching a session with open cursors not allowed

1 Answers  


DGM-16905: Failed.

1 Answers  


DGM-17002: Primary database can not be removed.

1 Answers  


ORA-02360: fatal error during data export/import initialization

1 Answers  


ORA-31038: Invalid string value: "string"

1 Answers  


ORA-24366: migratable user handle is set in service handle

1 Answers  


Categories