Hi all,
I am still in shock over the announcement to make Spatial free. Were my brain to be autopsied at this moment, there are millions of cells dedicated just to tracking the complicated licensing burden for Spatial. Somehow I need to recycle those.
But a real question. I am in the midst of a migration from 12cR1 to 18cR0 and found that following the upgrade, my custom SRIDs at 1000001 and 1000002 were overwritten with SRIDs for "Radolan" coordinate systems. The 18c documentation is clear that one million and above remain for custom use:
https://docs.oracle.com/en/database/oracle/oracle-database/18/spatl/coordinate-systems-concepts.html#GUID-FE6B0C7A-7A72-…
I don't think the folks doing the upgrade know enough about Spatial to somehow add these either on purpose or by accident. Could I ask what the rest of you using 18c have in your 1000001 and 1000002 slots? Radolan seems to be a German commercial ground and space radar system. I did search metalink for the topic with no luck.
In the end I could just move my SRIDs further down and migrate the data - buts its all raster data and a bit of work to do.
Thanks,
Paul
Before migration on 12cR1
After migration on 18cR0
Note that 1000001 can be replaced with 5070 that was added at 12c. 1000003 is available as 3338 now as well. My original custom items are over a decade old and date back to the 10g days long before Oracle added 5070 and 3338.