Spatial Indexing Issue

794
2
08-07-2020 03:18 AM
AdnanYounas2
New Contributor II

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

0 Kudos
2 Replies
George_Thompson
Esri Frequent Contributor

I would first recommend applying this patch to your ArcGIS 10.6.1 desktop; ArcGIS (Desktop, Engine, Server) Support for Oracle 19c Patch . Then I would update the geodatabase to the the same level as Desktop, then re-test the work flow. Oracle database requirements for ArcGIS 10.6.x ArcGIS Pro 2.1 and 2.2—System Requirements | Document... 

That issue does sound slightly weird.

--- George T.
0 Kudos
AdnanYounas2
New Contributor II

Hi Thompson,

Thanks for your response. The mentioned patch has already been applied. Also in ArcSDE version tables shows the below information:

10.6.1 Geodatabase.

Would it help to rerun the upgrade again? OR run the create spatial type again (ST_GEOMETRY) again? Or any other thought would be appreciated.

Thanks.

0 Kudos