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


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

SQL*Loader-00284: Warning: Input data file string specified multiple times.

1 Answers  


NNL-00264: Request forwarding is now disabled

1 Answers  


ORA-30369: maximum number of columns is 32

1 Answers  


ORA-30046: Undo tablespace string not found in controlfile.

1 Answers  


ORA-27069: attempt to do I/O beyond the range of the file

1 Answers  






ORA-12421: different size binary labels

1 Answers  


ORA-00409: COMPATIBLE needs to be string or higher to use AUTO SEGMENT SPACE MANAGEMENT

1 Answers  


ORA-09956: scgcm: unexpected lock status condition

1 Answers  


ORA-04000: the sum of PCTUSED and PCTFREE cannot exceed 100

1 Answers  


ORA-19558: error de-allocating device

1 Answers  


QSM-01011: when heuristic rewrite not set, rewrite hint required

1 Answers  


PLS-00726: MODIFY ELEMENT is supported only on schema-level varray and nested tables

1 Answers  






Categories