Posted on behalf of a Bentley Exor user.
following an update last night we appear to have lost one spatial index (perhaps more). Arcmap is now giving the following error:
one or more layers failed to drawspatial index does not exist ora-13226: interface not supported without a spatial indexora-06512: at "mdsys.md", line 1723ora-06512: at "mdsys.mderr", line 8ora-06512: at "mdsys.sdo_3gl", line 537*.v_nm_no_road_sdo
You will need to recreate the spatial index. In most cases you should be able to do this via the GIS Layer Tool. However in this occasion, the error is on one of the nodes views (V_NM_NO_ROAD_SDO) which seems to suggest that its the base table (NM_POINT_LOCATIONS) that is missing a spatial index.
To create it just run the following sql statement:
create index nm_point_locations_spidx on nm_point_locations(npl_location)indextype is mdsys.spatial_index
Note if you need to drop the spatial index the statement is:
drop index nm_point_locations_spidx
Pano Voudouris | Senior Support Engineer
Answer Verified By: Sarah Willis-Culpitt
This has worked fine, thanks Pano.
User has now added:
I hadn't noticed earlier that the three main NSG theme layers are not displayed either, as I don't have much call to use them.
(V_NM_NAT_NSGN_OFFN_SDO_DT)
(V_NM_NAT_NSGN_RDNM_SDO_DT)
(V_NM_NAT_NSGN_UOFF_SDO_DT)
I tried a fresh layer display for each.
The layer loads across, but the features were not displaying.
I selected a record from the attribute table and zoomed to it.
I then got the same spatial index error as for the nodes.
PS the reason I log formally is 1: to get a reference number 2: to be able to prioritise. Forums are fine for advice, discussion, but NOT for serious issues.
Thanks Julia, OK, can you please mark this as answered then? You could raise the problem with the other layers as a separate tiket through the standard help channel. However its a pretty easy workflow:
In the GIS Layer tool form you query back the nsg layers
Click on the [Get Themes] button
Select the base table (in case of OFFN this would be NM_NAT_NSGN_OFFN_SDO)
Click the > button on the right hand side of the form- this will expand the form.
In the SDO metadata tab click the [Rebuild Index] button.
Repeat for the other Street Layers (RDNM, UOFF)
Thanks Pano, all looks good now. Happy with answers but don't know how to mark the post as Answered (other than to give you 5 stars!)
:-) Thanks Julia. There should be a little panel under every post/reply stating "DId this answer your question?" And a button next to it saying Yes - that's the one!