How to add User Defined Coordinate Systems using a traditional insert into MDSYS.CS_SRS in 10gR2 and 11g?
Last updated on FEBRUARY 13, 2018
Applies to:Oracle Spatial and Graph - Version 10.2.0.1 to 220.127.116.11 [Release 10.2 to 11.1]
Information in this document applies to any platform.
Creating a user-defined coordinate system before 10g Release2 (V10.2) has been done via inserting a row with the Open Geospatial Consortium Well-Known Text (OGC WKT) into the MDSYS.CS_SRS table. As of V10.2 onwards, coordinate system support is based upon the European Petroleum Survey Group (EPSG) model which is implemented using different table structures.
For more information about this new implementation please see for example:
Spatial User's Guide and Reference 10g Release 2
The EPSG model is more flexible, but it is also more complicated to add a new User Defined Coordinate System as it requires inserts into multiple tables.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms