QSM-02148: many to many subquery joins require 9.0
compatibility or higher



QSM-02148: many to many subquery joins require 9.0 compatibility or higher..

Answer / guest

Cause: You have specified a many to many join in your
materialized view while running in less than 9.0
compatibility mode.

Action: Set your compatibility mode to 9.0 or higher or
restructure the materialized view query.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

QSM-02101: mv references a synonym in the FROM list

1 Answers  


ORA-24397: error occured while trying to free connections

1 Answers  


ORA-25158: Cannot specify RELY for foreign key if the associated primary key is NORELY

1 Answers  


RMAN-06703: could not open file: "string" (reason=string)

1 Answers  


SQL-02114: Invalid SQL Cursor usage: trying to CLOSE a CLOSEd cursor

1 Answers  






NCR-02004: NCRF: Invalid format interpreter type context

1 Answers  


ORA-13610: The directive string does not exist for task string.

1 Answers  


PCC-00103: AT clause is an Oracle extension

1 Answers  


TNS-12201: TNS:encountered too small a connection buffer

1 Answers  


ORA-30442: can not find the definition for filter string

1 Answers  


TNS-00541: underlying transport does not exist.

1 Answers  


How to Select 38th row details in table without using rownum ?

12 Answers   ProKarma, Sapient, Wipro,


Categories