Here is my case. I had 2 geodatabases. Second one is created later. And i import all tables in geodatabase-1 to geodatabase-2 by using ArcCatolog. I use srid 6 for my geodatabase 1 and its kind of a standart. But in geodatabase 2 the tables and indexes are imported with an different srid. I have to change srid of all geometry collumns and spatial indexes to 6.
First i checked ST_spatial_references table for srid 6 and couldnt find it. There is srid 30002 with same content with srid 6 in geodatabase 1.
Then i create an entry in ST_Spatial_references table manually for srid 6. After that I tried to create a spatial index with following query.
CREATE INDEX SDE.INDEX_NAME ON SDE.TABLE_NAME (SHAPE)
INDEXTYPE IS SDE.ST_SPATIAL_INDEX
and get this error. ORA-20085: Different SRID '6' do not match.
I need to create and srid entry with id 6 properly. And change all the tables and spatial indexes set to srid 6. Can anyone help me?
Note: srid 30002 and 6 has exactly same content in ST_SPATIAL_REFERENCES table except the id collumn.