Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-23406: insufficient privileges on user "string"

1 Answers  


SQL*Loader-00124: specified value for readsize(number) less than bindsize(number)

1 Answers  


ORA-25229: error on transformation of message string string

1 Answers  


ORA-13772: unexpected deadlock on "SQL Tuning Set" "string"

1 Answers  


ORA-32591: connect string too long

1 Answers  






ORA-38776: cannot begin flashback generation - flash recovery area is disabled

1 Answers  


IMG-00718: the same Temporary LOB cannot be used as both source and destination

1 Answers  


ORA-12334: database (link name string) is still open

1 Answers  


PLS-00307: too many declarations of 'string' match this call

1 Answers  


ORA-19588: %s recid string stamp string is no longer valid

1 Answers  


LPX-00307: namespace prefix ~S used but not declared

1 Answers  


PCB-00306: CREATE FUNCTION/PROCEDURE/PACKAGE/TRIGGER are Oracle extensions

1 Answers  






Categories