Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-00160: global transaction length string is greater than maximum (string)

1 Answers  


ORA-14521: Default tablespace string block size [string] for string string does not match existing string block size [string]

1 Answers  


PROT-00410: Please ensure you have file creation privileges in the executing directory before running this tool.

1 Answers  


ORA-02804: Allocation of memory failed for log file name

1 Answers  


ORA-00108: failed to set up dispatcher to accept connection asynchronously

1 Answers  






ORA-16209: Logical standby dictionary build failed to complete.

1 Answers  


PLS-00389: table, view or alias name "string" not allowed in this context

1 Answers  


PLS-00624: USING clause must be used with either aggregate or pipelined functions

1 Answers  


TNS-12515: TNS:listener could not find a handler for this presentation

1 Answers  


NZE-29135: Seed generation for Random Number Generator failed.

1 Answers  


ORA-29299: Invalid handle for piecewise compress or uncompress

1 Answers  


ORA-13032: Invalid NULL SDO_GEOMETRY object

1 Answers  






Categories