Community

Spatial Indexing Issue

3132
12
08-09-2020 12:52 AM
AdnanYounas2
by
New Contributor II
‎08-09-2020 12:52 AM

Whenever I create a new feature class with ST_Geometry column, It's created without any issue but I cannot insert data into it until unless I remove the spatial index from it.

 

I have tried the following things:

 

1- Also when I delete the Spatial Index I can enter the data and all works fine but

2- Later if I want to create a spatial Index on the same layer, it doesn't work. I can click on the "create" button but no spatial index name appears or

3- If I do it through the tool it says "Succeeded" about the spatial index creation but cannot see the index. 

4- Rebuild Index button is disabled. 

 

Any suggestion, why is this behavior and how to fix it?

 

ArcGIS Desktop 10.6.1, ArcSDE 10.6, Oracle 19c.

 

Thanks

 

Younus

12 Replies
Arne_Gelfert
by
Occasional Contributor III
‎08-11-2020 01:15 PM

Did you see this?

Error: DBMS table not found [ORA- 00942 : table or view does not exist] 

AdnanYounas2
by
New Contributor II
‎08-11-2020 10:40 PM

Thanks for asking.

I can create the layer without any error and issue, even I can see insert data using the schema owner. Issue is with the application/other user. I am getting an error if I have a spatial index enabled. Details can be seen in the above thread.

0 Kudos
ElliottPete
by
New Contributor
‎07-01-2021 04:35 PM

1- Also when I delete the Spatial Index I can enter the data and all works fine but

2- Later if I want to create a spatial Index on the same layer, it doesn't work. I can click on the "create" button but no spatial index name appears or

3- If I do it through the tool it says "Succeeded" about the spatial index creation but cannot see the index. 

4- Rebuild Index button is disabled. 

I know this is an old thread, but I had this exact issue with a file geodatabase in 10.6.1. It does not seem like your issue was ever resolved, so here's what worked for me:

 

1. In ArcCatalog, delete the spatial index using the "Delete" button in the feature class's Properties window under the Indexes tab

2. Run "Remove Spatial Index" geoprocess / tool

3. Run "Add Spatial Index" geoprocess / tool

 

It might be helpful to close and re-open ArcCatalog between every step to make sure everything is fresh (kind of like rebooting your computer). After that, I successfully had a spatial index in my feature class.

 

You could also try the "Rebuild Indexes" geoprocess / tool. I know you are not using a file geodatabase, but maybe this will work!