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

NCR-04022: NCRR: Invalid procedure descriptor

1 Answers  


ORA-01174: DB_FILES is string buts needs to be string to be compatible

1 Answers  


ORA-02092: out of transaction table slots for distributed transaction

1 Answers  


ORA-25295: Subscriber is not allowed to dequeue buffered messages

1 Answers  


ORA-07281: slsget: times error, unable to get cpu time.

1 Answers  






IMG-00506: extra value in CUT rectangle

1 Answers  


RMAN-20003: target database incarnation not found in recovery catalog

1 Answers  


PLS-00483: exception 'string' may appear in at most one exception handler in this block

1 Answers  


PLS-00335: a package name conflicts with an existing object

1 Answers  


ORA-38487: FUNCTION/PACKAGE/TYPE "string" not allowed in the expression

1 Answers  


ORA-02726: osnpop: access error on oracle executable

1 Answers  


RMAN-06201: Deleted string objects

1 Answers  


Categories