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

ORA-38499: expression set already configured for stored/indexed attributes

1 Answers  


ORA-02329: column of datatype string cannot be unique or a primary key

1 Answers  


ORA-22285: non-existent directory or file for string operation

1 Answers  


IMG-00003: exhausted memory while processing image

1 Answers  


ORA-32844: exceeded maximum number of string values

1 Answers  






ORA-01482: unsupported character set

1 Answers  


ORA-29876: failed in the execution of the ODCIINDEXDELETE routine

2 Answers  


NNL-00408: Answers:

1 Answers  


ORA-38749: A media recovery has been started.

1 Answers  


PLS-00609: the OVERRIDING clause is not valid for SQLJ Object Types

1 Answers  


ORA-01329: unable to truncate require build table

1 Answers  


ORA-01341: LogMiner out-of-memory

1 Answers  


Categories