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

ORA-29252: collection does not contain elements at index locations in call to dbms_sql.bind_array

1 Answers  


NNL-00896: Requests refused, modifications disabled: number

1 Answers  


RMAN-06167: already connected

1 Answers  


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

1 Answers  


PCB-00581: "string" used as both host variable and indicator

1 Answers  


ORA-19597: file string blocksize string does not match set blocksize of string

1 Answers  


ORA-24757: duplicate transaction identifier

1 Answers  


ORA-16631: Operation requires shutdown of database/instance "string"

1 Answers  


PLS-00209: table 'string' is not in FROM clause

1 Answers  


TNS-12616: TNS:no event signals

1 Answers  


RMAN-06590: tablespace string cannot be converted

1 Answers  


ORA-00208: number of controlfile names exceeds limit of string

1 Answers  


Categories