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
Article ID: 000009568
Get help from ArcGIS experts
Download the Esri Support App