Spatial Index missing

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 draw
spatial index does not exist ora-13226: interface not supported without a spatial index
ora-06512: at "mdsys.md", line 1723
ora-06512: at "mdsys.mderr", line 8
ora-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)

    Pano Voudouris | Senior Support Engineer

  • 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!

    Pano Voudouris | Senior Support Engineer