Create Materialized View Fails With ORA-30372

Posted by David Purge on Nov 03, 2015; 7:36pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Create-Materialized-View-Fails-With-ORA-30372-tp434.html

Hi Erman,

While I create MV i get an error ORA-30372,after that I had grant EXEMPT ACCESS POLICY to apps
But now I'am getting ORA-38818: illegal reference to editioned object XLE.XLE_ENTITY_PROFILES#

ı checked SELECT username,editions_enabled
FROM   dba_users where username='XLE' and 'APPS'  it returned Y.


I am trying with apps;

and here is my create script;

Create materialized view APPS.XXPC_SLA_GMF_FISLER_MV
BUILD IMMEDIATE
refresh complete
START WITH (sysdate) --+0.1/24
NEXT (sysdate) + 1
AS
SELECT *
from APPS.XXPC_SLA_GMF_FISLER_V