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


QSM-02153: inline view or subquery in FROM list not
supported for this type MV



QSM-02153: inline view or subquery in FROM list not supported for this type MV..

Answer / guest

Cause: You have specified a materialized view that
references an inline view or a subquery. The indicated
capability is not supported for this type of materialized view.

Action: 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-00269: specified log file is part of thread string not string

1 Answers  


TNS-04071: Connections closed successfully. Number closed: number.

1 Answers  


TNS-00211: Total Active Pumps : number

1 Answers  


PLS-00229: Attribute expression within SQL expression

1 Answers  


PLS-00533: Tables of non_queryable types are not supported.

1 Answers  






RMAN-06502: skipping archive log file string; already backed on string

1 Answers  


ORA-23611: tablespace "string" has more than one data file

1 Answers  


RMAN-06009: using target database controlfile instead of recovery catalog

1 Answers   HP,


NNO-00613: disabling FORWARDING-DESIRED on system queries

1 Answers  


PCB-00314: DECLARE DATABASE is an Oracle extension

1 Answers  


PLS-00455: cursor 'string' cannot be used in dynamic SQL OPEN statement

1 Answers  


ORA-24055: cannot delete propagation status rows that are in prepared state

1 Answers  






Categories