PROBLEM
Creating an Oracle materialized view for a table containing an ST_Geometry attribute returns the following error:
"ORA-30373: object data types are not supported in this context".
Code:
SQL> CREATE MATERIALIZED VIEW parcel_view
2 AS SELECT * FROM parcel@remote_server;
CREATE MATERIALIZED VIEW parcel_view
*
ERROR at line 1:
ORA-30373: object data types are not supported in this context
Oracle's Advanced Replication functionality requires that all object types be defined as FINAL to participate within a materialized view.
Describe the ST_Geometry type in SQL*Plus and notice that the type is not defined as FINAL.
Code:
SQL> DESCRIBE sde.st_geometry
sde.st_geometry is NOT FINAL
Name Null? Type
------------------------------------------- -------- -----------
ENTITY NUMBER(38)
NUMPTS NUMBER(38)
MINX FLOAT(64)
MINY FLOAT(64)
MAXX FLOAT(64)
MAXY FLOAT(64)
MINZ FLOAT(64)
MAXZ FLOAT(64)
MINM FLOAT(64)
MAXM FLOAT(64)
AREA FLOAT(64)
LEN FLOAT(64)
SRID NUMBER(38)
POINTS BLOB
Get help from ArcGIS experts
Download the Esri Support App