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)
- V
It would be more accurate to say that Oracle doesn't support materialized views
on SDE.ST_GEOMETRY.
- V