My Oracle Support Banner

ORA-00904: "R"."XMLTYPE": invalid identifier AND Invalid Mviews After Upgrading from 11204 to 12.2 (Doc ID 2572753.1)

Last updated on APRIL 29, 2020

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


 After upgrading from 11204 to 12.2, Materialized views are invalid.

while running utlrp.sql after upgrade, the following errors are seen.

ERROR at line 1:
ORA-32044: cycle detected while executing recursive WITH query
ORA-06512: at "SYS.UTL_RECOMP", line 899
ORA-06512: at "SYS.UTL_RECOMP", line 513
ORA-06512: at "SYS.UTL_RECOMP", line 869
ORA-06512: at line 4

According to UTLRP.SQL Encounters ORA-32044 ORA-06512 (Doc ID 2054573.1), this is because of the invalid mviews.

After compiling the mview, it is compiled with error:

Refresh the mview or run the select and trace it.

ERROR at line 15:
ORA-00904: "R"."XMLTYPE": invalid identifier


Upgrade database form 11204 to 12.2 


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.