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

NNL-00811: Fastest query processing time: string

1 Answers  


ORA-36393: (XSMXCLEA03) When using the CHANGES or CACHE options, you must specify the ALL keyword.

1 Answers  


ORA-14029: GLOBAL partitioned index must be prefixed

1 Answers  


LPX-00405: unable to allocate memory

1 Answers  


ORA-13401: duplicate entry for string in USER_SDO_GEOR_SYSDATA view

1 Answers  






ORA-16542: unrecognized operation

1 Answers  


ORA-37043: (XSACQUIRE_DEP_OLDGEN) Composite, concat, dimension map, or internal partition workspace object cannot be locked since another user has committed a new one already.

1 Answers  


ORA-02446: CREATE TABLE ... AS SELECT failed - check constraint violated

1 Answers  


ORA-29913: error in executing string callout

1 Answers  


ORA-02176: invalid option for CREATE ROLLBACK SEGMENT

1 Answers  


ORA-14156: invalid number of subpartitions specified in [SUBPARTITIONS | SUBPARTITION TEMPLATE] clause

1 Answers  


SQL*Loader-00418: Bad datafile datatype for column string

1 Answers  


Categories