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

TNS-01152: All addresses specified for the listener name, string, failed

1 Answers  


ORA-37030: (XSMLTMAINT01) You cannot maintain workspace object because it is not ACQUIRED.

1 Answers  


ORA-13027: unable to read dimension definition from string

1 Answers  


ORA-02160: index-organized table can not contain columns of type LONG

1 Answers  


ORA-13839: V$SQL row doesn't exist with given HASH_VALUE and ADDRESS.

1 Answers  






RMAN-06195: auxiliary database not started

1 Answers  


ORA-19711: cannot use reNormalizeAllFileNames while database is open

1 Answers  


PLS-00633: RETURN statement in a pipelined function cannot contain an expression

1 Answers  


ORA-12659: Error received from other process

1 Answers  


ORA-36394: (XSMXCLEA04) When using CLEAR on the AGGMAP workspace object, CACHE is the only valid directive.

1 Answers  


PCC-02411: Invalid type for INDICATOR descriptor item host variable

1 Answers  


PLS-01406: An identifier has been found that is considered a keyword in ANSI's grammar but not in PL/SQL's

1 Answers  


Categories