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.
It's often useful to do a search on the error message. When I searched on "ORA-30373", the third reference was a Knowledge Base document, Since "materialized view" is just a fancy name for a table that is periodically repopulated by a query, you can model this yourself with SQL via CREATE TABLE ... AS SELECT ..., TRUNCATE TABLE, and INSERT INTO ... SELECT (be sure to manage the indexes as efficiently as possible)
sorry.I don't understand what you've said.It seems that ST_GEOMETRY type does not be supported by oracle MATERIALIZED VIEW .
It's often useful to do a search on the error message. When I searched on "ORA-30373", the third reference was a Knowledge Base document, Since "materialized view" is just a fancy name for a table that is periodically repopulated by a query, you can model this yourself with SQL via CREATE TABLE ... AS SELECT ..., TRUNCATE TABLE, and INSERT INTO ... SELECT (be sure to manage the indexes as efficiently as possible)
