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

PLS-00358: column 'string' exists in more than one table; use qualifier

1 Answers  


ORA-14158: too many subpartition descriptions

1 Answers  


ORA-12352: object string.string@string is invalid

1 Answers  


PCC-02018: found end-of-file while scanning comment

1 Answers  


ORA-39302: schema clone operation failed

1 Answers  






ORA-03236: max # extents (string) reached in index string.string subpartition string

1 Answers  


ORA-00204: error in reading (block string, # blocks string) of controlfile

1 Answers  


NZE-28842: Incorrect file permissions

1 Answers  


RMAN-06475: parallelism setting out of range (1-254): number

1 Answers  


PLS-00514: INSERT statement with REF INTO clause requires a typed table

1 Answers  


ORA-12855: cannot run parallel or insert direct load in a loopback

1 Answers  


TNS-12569: TNS:packet checksum failure

1 Answers  


Categories