Materialized View Creation Fails With "ORA-32331: type "MDSYS"."SDO_GEOMETRY" is incompatible with the master site"
Last updated on OCTOBER 19, 2017
Applies to:Oracle Spatial and Graph - Version 22.214.171.124 to 12.2 [Release 11.2 to 12.2]
Information in this document applies to any platform.
The creation of a Materialized view is failing with this error
ORA-32331: type "MDSYS"."SDO_GEOMETRY" is incompatible with the master site
The databases are identical with the same patch level
The actual CREATE MATERIALIZED VIEW statement is irrelevant
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms