CREATE MATERIALIZED VIEW ON ArcSDE

Question

I use ArcSDE V10.0 for Oracle10g(Oracle 10.2.0.4).Now I create a materialized view as following:
CREATE MATERIALIZED VIEW g_switch
AS SELECT objectid,shape FROM g_gadgets where class='SWITCH';

But it return s that:
"ORA-30373: object data types are not supported in this context".

The type of field "OBJECTID"  is INTEGER and "Shape" is ST_GEOMETRY.

but in Arcgis Desktop V10.0 help document,it works well(http://help.arcgis.com/en/arcgisdesktop/10.0/help/#/Using_spatial_views_on_tables_with_an_ST_Geometry_column/006z00000039000000/).

I want to know what's wrong and how can I do?

VinceAngelo · Answer

It should work, but it doesn't, for the reasons described in the KB doc.

I've requested that the Oracle example be removed from the Help until
it works properly.

- V

zmtylsabc · Answer

But in Arcgis Desktop V10.0 help document,it works well(http://help.arcgis.com/en/arcgisdesk...0000039000000).why?It would be more accurate to say that Oracle doesn't support materialized views
on SDE.ST_GEOMETRY.

- V

VinceAngelo · Answer

It would be more accurate to say that Oracle doesn't support materialized views
on SDE.ST_GEOMETRY.

- V