Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

QSM-02019

mv references another mv in FROM clause

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.