QSM-02151: subquery or named view in FROM list and < 9.0
compatibility



QSM-02151: subquery or named view in FROM list and < 9.0 compatibility..

Answer / guest

Cause: You have specified a materialized view that
references a subquery or named view in its top level FROM
list while running in less than 9.0 compatibility mode.

Action: Set 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-01647: tablespace 'string' is read only, cannot allocate space in it

2 Answers  


ORA-30132: invalid key index supplied

1 Answers  


PLS-00548: invalid use of operator.

1 Answers  


ORA-32610: missing SINGLE REFERENCE or DIMENSION keyword in MODEL clause

1 Answers  


DRG-10706: length of string exceeds maximum size of string

1 Answers  


DRG-12602: index owner does not have access to user datastore procedure: string

1 Answers  


ORA-09761: pw_destroyPorts: server call pws_stop_instance failed.

1 Answers  


RMAN-06909: WARNING: parallelism require Enterprise Edition

2 Answers  


NNO-00610: detected possible alias loop involving name "string"

1 Answers  


TNS-01097: TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE

1 Answers  


ORA-39126: Worker unexpected fatal error in string [string] string

1 Answers  


QSM-00513: one or more of the workload tables is missing

1 Answers  


Categories