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-38415: invalid name or datatype for the attribute: string

1 Answers  


NNL-00260: Server-generated requests now do not require authoritative answers

1 Answers  


RMAN-20218: datafile not found in recovery catalog

1 Answers  


ORA-18000: invalid outline name

1 Answers  


ORA-04014: descending sequences that CYCLE must specify MINVALUE

1 Answers  






ORA-24126: invalid CASCADE_FLAG passed to DBMS_REPAIR.string procedure

1 Answers  


ORA-33448: (ESDREAD04) Discarding compiled code for workspace object because number now has string data, whereas it had string data when the code was compiled.

1 Answers  


ORA-25122: Only LOCAL bitmap indexes are permitted on partitioned tables

1 Answers  


LSX-00344: namespace values "~1S" and "~2S" differ

1 Answers  


ORA-12678: Authentication disabled but required

1 Answers  


ORA-22954: This multiset operation is not supported for this element type.

1 Answers  


ORA-24057: cannot define subscriber with rule for queue string

1 Answers  


Categories