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

RMAN-08514: archive log filename=string recid=string stamp=string

1 Answers  


ORA-02219: invalid NEXT storage option value

1 Answers  


QSM-00515: operation cancelled by user

1 Answers  


ORA-39142: incompatible version number string in dump file "string"

1 Answers  


QSM-01106: MV, string, is stale with respect to some partition(s) in the base table(s)

1 Answers  






ORA-29910: invalid callback operation

1 Answers  


ORA-29312: changes by release string cannot be used by release string, type: string

1 Answers  


ORA-28507: error in data dictionary view string

1 Answers  


ORA-14105: RECOVERABLE/UNRECOVERABLE may not be specified in this context

1 Answers  


ORA-06540: PL/SQL: compilation error

1 Answers  


CLSS-02207: error string getting status from vendor node monitor

1 Answers  


LSX-00151: invalid combination of attributes "ref" and "name"

1 Answers  


Categories