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-03252: initial extent size not enough for LOB segment

1 Answers  


RMAN-20222: datafilename not found in recovery catalog or is ambiguous

1 Answers  


ORA-01417: a table may be outer joined to at most one other table

1 Answers  


TNS-02525: encryption/crypto-checksumming: self test failed

1 Answers  


ORA-38411: invalid datatype for the column storing expressions

1 Answers  






ORA-16119: building transaction at SCN string

1 Answers  


ORA-25457: evaluation function string returns failure

1 Answers  


ORA-09871: TASDEF_NAME: translation error while expanding ?/dbs/tasdef@.dbf.

1 Answers  


ORA-02732: osnrnf: cannot find a matching database alias

1 Answers  


ORA-14085: partitioned table cannot have column with LONG datatype

1 Answers  


ORA-30072: invalid time zone value

1 Answers  


ORA-24090: at least one protocol must be enabled

1 Answers  


Categories