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


QSM-02019: mv references another mv in FROM clause



QSM-02019: mv references another mv in FROM clause..

Answer / guest

Cause: The capability in question is not supported when the
materialized view is nested (i.e., when it references
another materialized view in its FROM list).

Action: Re-phrase the query to avoid reference to the other
materialized view.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-38701: Flashback database log string seq string thread string: "string"

1 Answers  


ORA-01876: year must be at least -4713

1 Answers  


RMAN-06042: PLUS ARCHIVELOG option is not supported with non-datafile backups

1 Answers  


DRG-11506: record ignored on line string because of error(s)

1 Answers  


NZE-28885: No certificate with the required key usage found.

1 Answers  






NNC-00417: name "string" already exists

1 Answers  


invalid quantity specification negative quantity are not allowed for this item please check this item definition quantity

0 Answers  


NZE-29223: Cannot create certificate chain.

1 Answers  


ORA-16624: broker protocol version mismatch detected

1 Answers  


ORA-19661: datafile string could not be verified

1 Answers  


NZE-28763: Invalid parameter type found in configuration file.

1 Answers  


ORA-29835: ODCIGETINTERFACES routine does not return required interface(s)

1 Answers  






Categories