I am assuming that your geodatabase is upgraded to 10.6.1.
Thanks for your response.
The Client and Server both are on 10.6.1.
We are facing the ST_Geometry related issue on this Database with almost all the schemas I have checked so far.
We have another environment but different version and working fine with same data.
Here is the other thread with the same question: Spatial Indexing Issue
Adnan Younas - in the other thread you mentioned running the Create Spatial Type (Data Management)—ArcMap | Documentation tool.
Is this the only tool that you ran on the Oracle DB?
If so, this does not create an Enterprise Geodatabase and may be part of the behavior.
No, what I was trying to suggest what if I re-ran this tool Create Spatial Type (Data Management)—ArcMap | Documentatiagain to fix any anomalies left behind?
As I have checked almost everything I could think of and database got all the references of spatial index but with the spatial index we cannot insert data and if I remove it all works except I cannot recreate spatial index using ArcCatalog etc.
Ok, did you run the Create or Enable Enterprise Geodatabase tool also?
If so, before or after you ran the Create Spatial Type GP tool?
If you ran both, I am wondering if there is an issue behind the scenes.
It was upgraded from 10.2.2 to 10.6.1.
I am not sure about when it was ran but I guess we didnt run after the upgrade.
Also an interesting fact with more experiments on the schema:
User --> Schema owner: I inserted data into the table with spatial index enabled --> worked fine without an issue and row inserted.
Application User: Same Insert statement ran with spatial index and got the following error with the spatial index but data was inserted when I removed the spatial index. Checked the permissions though and looks fine.
ERROR at line 1:
ORA-29875: failed in the execution of the ODCIINDEXINSERT routine
ORA-00942: table or view does not exist
ORA-06512: at "SDE.SPX_UTIL", line 1147
ORA-06512: at "SDE.SPX_UTIL", line 1204
ORA-06512: at "SDE.ST_DOMAIN_METHODS", line 2023
After interesting the data now I cannot create the spatial index same problem I mentioned earlier.
I hope I manage to explain it well. Please suggest.
Honestly at this point, I would work with technical support on this issue. They may be able to help narrow down the issue based on the workflow.
If you upgraded from 10.2.x --> 10.6.x, then you would NOT need to run the Create Spatial type or Enterprise GDB tools after the upgrade.