DBMS_MVIEW.EXPLAIN_MVIEW failed with ORA-32341
(Doc ID 2652289.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 18.4.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
Explain Mview failed with below errors in non-Exadata with zonemaps.
SQL> Begin
2 DBMS_MVIEW.EXPLAIN_MVIEW ('<owner>.test_mv');
3 end;
4 /
Begin
*
ERROR at line 1:
ORA-32341: The EXPLAIN_MVIEW facility failed to explain the materialized view "<owner>"."TEST_MV"
ORA-12003: materialized view or zonemap "<owner>"."TEST_MV" does not exist
ORA-06512: at "SYS.DBMS_XRWMV", line
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |