'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 |
|---|
