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


QSM-02052: subquery using a select list in mv



QSM-02052: subquery using a select list in mv..

Answer / guest

Cause: The capability in question is not supported when the
materialized view uses a select list.

Action: Re-phrase the query to avoid the use of a select list.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

PLS-00590: attempting to create a subtype UNDER a FINAL type

1 Answers  


SQL-02110: Inconsistent host cache. Invalid host cache entry type

1 Answers  


O2F-00306: Unable to close the INTYPE file

1 Answers  


QSM-02026: non-AND conjunction in WHERE clause

1 Answers  


ORA-07846: sllfop: string byte record too big for string byte user buffer

1 Answers  






ORA-03234: unable to extend index string.string subpartition string by string in tablespace string

1 Answers  


NCR-03010: NCRO: Transfer callback error

1 Answers  


RMAN-06013: duplicate channel identifier found: string

1 Answers  


ORA-23411: materialized view "string"."string" is not in refresh group "string"."string"

1 Answers  


ORA-01179: file string does not exist

1 Answers  


NCR-01009: NCRS: Record handling error.

1 Answers  


LSX-00157: "~S" is abstract and cannot be used in an instance document

1 Answers  






Categories