QSM-02112: top level query has LEFT OUTER, RIGHT OUTER or
FULL OUTER join



QSM-02112: top level query has LEFT OUTER, RIGHT OUTER or FULL OUTER join..

Answer / guest

Cause: The capability in question is not supported when the
materialized view uses these types of joins.

Action: Re-phrase the query to avoid the use of these types
of 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-27041: unable to open file

1 Answers  


NNL-00874: Slowest update processing time: string

1 Answers  


KUP-04013: other system error

1 Answers  


ORA-19909: datafile string belongs to an orphan incarnation

2 Answers  


ORA-16413: Unsupported database type for ONDEMAND archivelog destinations

1 Answers  






RMAN-06471: no configuration found to allocate channels for string

1 Answers  


ORA-30558: internal error [string] in function based index

1 Answers  


ORA-07448: ssarena: maximum number of shared arenas exceeded.

1 Answers  


ORA-27047: unable to read the header block of file

2 Answers  


ORA-12462: undefined compartment string for policy string

1 Answers  


ORA-08117: Index Organized Table operation released its block pin

1 Answers  


SQL*Loader-00934: Incorrect data file string specified for table string

1 Answers  


Categories