My Oracle Support Banner

ORA-21700 During Materialized View Refresh on Table with a Spatial Column (UDT) but Materialized View Does Not Reference Spatial Column (Doc ID 1617040.1)

Last updated on NOVEMBER 07, 2023

Applies to:

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


A distributed materialized view (mview) refresh fails with ORA-21700 when there is a spatial column on the primary table, but the mview does not contain that column and the target database does not contain the datatype.


Upgrade from 9i to 11gR2 (used to work in 9i).   In this case, the user-defined datatype (UDT) was from a third-party application, and the license did not let them define this in the target (mview) database.


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.