DBMS_MVIEW.EXPLAIN_MVIEW failed with ORA-32341
(Doc ID 2652289.1)
Last updated on JULY 15, 2021
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
Explain Mview failed with below errors in non-Exadata with zonemaps.
2 DBMS_MVIEW.EXPLAIN_MVIEW ('<owner>.test_mv');
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
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