Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

ORA-22304: input type is not an object type

1 Answers  


DRG-11864: Unknown Access Authentication Scheme

1 Answers  


ORA-06557: null values are not allowed for any parameters to pipe icd's

1 Answers  


ORA-21600: path expression too long

1 Answers  


ORA-29351: can not transport system, sysaux, or temporary tablespace 'string'

1 Answers  






LFI-01517: open() failed(OSD return value = string).

1 Answers  


ORA-00102: network protocol string cannot be used by dispatchers

1 Answers  


ORA-16786: Resource guard cannot access Data Guard metadata

1 Answers  


ORA-06566: invalid number of rows specified

1 Answers  


ORA-27042: not enough space on raw partition to fullfill request

1 Answers  


ORA-23333: column string is already part of a column group

1 Answers  


NZE-29047: Mismatch in Transport Layer Security extension

1 Answers  






Categories