QSM-02059: join may produce duplicate rows in mv



QSM-02059: join may produce duplicate rows in mv..

Answer / guest

Cause: The capability in question is not supported when the
materialized view contains a join condition that can result
in duplicate rows in the materialized view.

Action: Re-phrase the query to avoid the occurrence of
duplicate rows in the materialized view.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-02075: another instance changed state of transaction string

1 Answers  


ORA-09957: Unable to send termination request to IMON

1 Answers  


ORA-37011: (XSACQUIRE_LOCKED) Object workspace object is locked by another user.

1 Answers  


ORA-14515: only one aubpartition name can be specified

1 Answers  


ORA-36802: (XSTBLFUNC01) The OLAP_TABLE function must contain a DATAMAP that executes a FETCH command or a LIMITMAP.

1 Answers  






ORA-02174: Missing required thread number

1 Answers  


ORA-36997: (XSRELGID14) For variable or relation grouping ids, a level relation is needed when a level order valueset is specified.

1 Answers  


QSM-02127: not supported for this type mv by Oracle version at master site

1 Answers  


IMG-00862: assert failure, inconsistency in merged area labels

1 Answers  


NZE-28784: file name translation failure

1 Answers  


ORA-12583: TNS:no reader

1 Answers  


TNS-00012: INTCTL: error while processing Connection Manager request

1 Answers  


Categories