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-02835: Server unable to send signal to client

1 Answers  


TNS-04142: CMAN.ORA file has an invalid format.

1 Answers  


ORA-00165: migratable distributed autonomous transaction with remote operation is not allowed

1 Answers  


PCC-02308: identifier required in this function declaration

1 Answers  


ORA-16086: standby database does not contain available standby log files

1 Answers  






NID-00333: Cannot read the header of the following datafiles:

1 Answers  


IMP-00062: Warning: The identifier on the dump file for object type "string"."string" is invalid

1 Answers  


ORA-25959: join index must be of the bitmap type

1 Answers  


IMG-00707: unable to access image data

1 Answers  


ORA-16763: log transport service for some standby database unexpectedly online

1 Answers  


ORA-02195: Attempt to create string object in a string tablespace

1 Answers  


NCR-03012: NCRO: Invalid session mode

1 Answers  


Categories