'Create MVIEW throws error - ORA-38818: illegal reference to editioned object

I am new to oracle. I am using oracle database 19c. I need to create materialized view from an editioned view. I get rule violation due to creation of non-editioned materialized view. Is there a way to either make the materialized view editioned or create it without reference? Thanks in advance!!

38818, 00000, "illegal reference to editioned object %s.%s"
// *Cause:  An attempt was made to violate the rule "A noneditioned object
//          may not depend on an editioned object."
// *Action: Either make this object editioned; or do not make the illegal
//          reference.

SQL> create table t as select * from dba_source;

SQL>create force editionable view dv as select * from t;

View created.

SQL>create materialized view mv as select * from edition_test.dv;
create materialized view mv as select * from edition_test.dv
               *
ERROR at line 1:
ORA-38818: illegal reference to editioned object EDITION_TEST.DV

When i trace the error, i get the line below.

PARSE ERROR #139985777303760:len=29 dep=1 uid=109 oct=3 lid=109 tim=31368654871 err=10980
select * from edition_test.dv


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source