Back in the days we used a spatial reference (SRID) of 2 in our databases. This was at the beginning of the st_geometry type era and what I remember the 3006 wasnt available. However the coding is exactly the same. For several reasons we now want to change this once and for all to 3006. According to this article this should be very easy: https://support.esri.com/en/technical-article/000010463
The problem is when I made all the steps the layer isn't visible any more in Arcmap. It doesn't draw anything.
In short I do this:
- Copy an existing feature class in arcmap for test. Lets say I copy feature class LAKE to LAKE_COPY.
- Then I remove any spatial index on LAKE_COPY.
- As the schema owner, with sql: UPDATE LAKE_COPY SET shape = sde.st_transform(shape,3006);
- As SDE-user: UPDATE st_geometry_columns SET srid = 3006 WHERE table_name = 'LAKE_COPY';
- Then I recreate the spatial index on LAKE_COPY.
- Now I try to view the converted layer in Arcmap but nothing shows up.
When checking SDE.ST_GEOMETRY_COLUMNS, SDE.LAYERS everything seems to be updated correctly. If I check existing shape data in de LAKE_COPY feature class I can see that it now has 3006 as spatial reference.
What has gone wrong? Should I do something else?
Environment: ArcGIS 10.3.1 and Oracle 11.2
