Re: XML materialized view

Posted by ErmanArslansOracleBlog on
URL: http://erman-arslan-s-oracle-forum.114.s1.nabble.com/XML-materialized-view-tp9948p9949.html

DBMS_MVIEW.EXPLAIN_MVIEW can be used to highlight what is supported for the mview in question.
Ref: How to Build a Materialized View Containing an XMLTYPE Column (Doc ID 1489788.1)

However; you have that xmltable function in your MV..
Materialized views are not eligible for fast refresh if their query contains an analytic function or --> the XMLTable function.
So this is a known restriction.. I think it answers your question.

See -> Restrictions on FAST Refresh -- in docs.oracle