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

RMAN-03017: recursion detected in stored script string

1 Answers  


RMAN-06107: WARNING: controlfile is not current for REPORT NEED BACKUP DAYS

1 Answers  


ORA-26041: DATETIME/INTERVAL datatype conversion error

1 Answers  


ORA-01643: system tablespace can not be made read only

1 Answers  


ORA-06105: NETTCP: remote host is unknown

1 Answers  






PLS-00662: Non-external object types containing external mapped attributes are not allowed

1 Answers  


DRG-11120: failed to write to file string

1 Answers  


ORA-21612: key is already being used

1 Answers  


ORA-16754: Resource guard could not activate standby

1 Answers  


ORA-01290: cannot remove unlisted logfile string

1 Answers  


ORA-08108: may not build or rebuild this type of index online

1 Answers  


ORA-00216: controlfile could not be resized for migration from 8.0.2

1 Answers  


Categories