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-29397: cannot grant/revoke switch privilege for string

1 Answers  


ORA-24358: OCIBindObject not invoked for a Object type or Reference

1 Answers  


DRG-11877: This Cache Version Has Expired And Will Be Automatically Reloaded

1 Answers  


RMAN-06058: a current controlfile cannot be included along with a standby controlfile

1 Answers  


PCC-02395: Using arrays of structs requires that the struct be named

1 Answers  


PLS-01425: Connect-by clause

1 Answers  


ORA-32018: parameter cannot be modified in memory on another instance

1 Answers  


ORA-06545: PL/SQL: compilation error - compilation aborted

1 Answers  


PCB-00401: Character string not properly terminated

1 Answers  


ORA-02223: invalid OPTIMAL storage option value

1 Answers  


ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode

1 Answers  


ORA-24186: wrong object type, could not transform message

1 Answers  


Categories