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-14004: missing PARTITION keyword

1 Answers  


ORA-19660: some files in the backup set could not be verified

1 Answers  


ORA-01296: character set mismatch between dictionary string and logfiles

1 Answers  


ORA-02758: Allocation of internal array failed

1 Answers  


ORA-01210: data file header is media corrupt

1 Answers  






ORA-22916: cannot do an exact FETCH on a query with Nested cursors

1 Answers  


QSM-00756: the specified workload string is being used by one or more advisor tasks

1 Answers  


TNS-00550: disconnection error

1 Answers  


TNS-01062: The db subagent is already running.

1 Answers  


RMAN-06725: database not open: sort area size too small

1 Answers  


PCC-02109: SQLCHECK=NONE is no longer supported.. using SYNTAX

1 Answers  


ORA-25403: could not reconnect

1 Answers  


Categories