QSM-02061: one or more joins present in mv



QSM-02061: one or more joins present in mv..

Answer / guest

Cause: The capability in question is not supported when the
materialized view contains joins.

Action: Re-phrase the query to avoid the use of the joins.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

PLS-00587: a static method cannot be invoked on an instance value

1 Answers  


PLS-00664: Both ORDER BY and CLUSTER BY can not be specified for the same table function

1 Answers  


ORA-16636: the object is permanently disabled

1 Answers  


ORA-09765: osnmop: fork failed

1 Answers  


ORA-31513: unsupported column type specified in change table

1 Answers  






ORA-30052: invalid lower limit snapshot expression

2 Answers  


ORA-14500: LOCAL option not valid without partition name

1 Answers  


NZE-29243: the toolkit does not recognize the type of key being used

1 Answers  


O2F-00317: Error opening the ERRTYPE file for writing

1 Answers  


ORA-10576: Give up restoring recovered datafiles to consistent state: some error occurred

1 Answers  


ORA-24355: attempt to store a negative number in an Unsigned Display type.

1 Answers  


PCC-00110: Oracle extension to the WHENEVER statement

1 Answers  


Categories