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