QSM-02096: mv references a named view



QSM-02096: mv references a named view..

Answer / guest

Cause: The capability in question is not supported when the
materialized view references a view.

Action: Re-phrase the query to avoid references to views.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

NZE-29155: continuous key pair consistency check self-test failure

1 Answers  


ORA-07402: sprst: cannot restore user signal handler.

1 Answers  


ORA-37043: (XSACQUIRE_DEP_OLDGEN) Composite, concat, dimension map, or internal partition workspace object cannot be locked since another user has committed a new one already.

1 Answers  


ORA-29871: invalid alter option for a domain index

1 Answers  


ORA-00033: current session has empty migration password

1 Answers  






ORA-16770: physical standby database not in read-only state.

1 Answers  


DGM-16916: Missing site name. Try "help"

1 Answers  


ORA-14256: invalid resulting partition description(s)

1 Answers  


ORA-22904: invalid reference to a nested table column

1 Answers  


ORA-14401: inserted partition key is outside specified partition

1 Answers  


NNO-00153: warning: hint domain number has invalid name "string", hint domain ignored

1 Answers  


RMAN-06606: RMAN configuration parameters are successfully reset to default value

1 Answers  


Categories