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-24386: statement/server handle is in use when being freed

1 Answers  


ORA-19300: Error occurred in uri processingstring

1 Answers  


ORA-07750: slemcr: fopen failure

1 Answers  


ORA-12051: ON COMMIT attribute is incompatible with other options

1 Answers  


TNS-12562: TNS:bad global handle

1 Answers  






LPX-00110: invalid ~1s "~2S" (not a Name)

1 Answers  


ORA-01944: IDENTIFIED EXTERNALLY already specified

1 Answers  


ORA-16805: Change of LogXptMode property violates overall protection mode.

1 Answers  


ORA-31497: invalid value specified for first_scn

1 Answers  


SQL*Loader-00431: illegal NULLIF or DEFAULTIF clause specified for nested table column string

1 Answers  


ORA-39121: Table string can't be replaced, data will be skipped. Failing error is: string

1 Answers  


RMAN-04005: error from target database: string

1 Answers  


Categories