Materialized Views and Spatial indexing in PL/SQL

555469

Hi

I've generated some PL/SQL to generate a range of MVs based upon a single spatial table. Each MV will represent a filter based upon a utility domain (gas, sewer, water etc) as this will speed up the rendering in Geoserver.

My code generates the MV and inserts the appropriate metadata into user_sdo_geom_metadata.

However, when I attempt to generate the spatial index using this syntax:

execute immediate 'create index VST_'||t.ASSETDOMAIN||'_SG on VST_'||t.ASSETDOMAIN||' (geometry) indextype is mdsys.spatial_index';

I get an ora-00942: table or view does not exist error.

I've no idea what's the problem

Can anyone help?

many thanks

Ant