How to add User Defined Coordinate Systems using a traditional insert into MDSYS.CS_SRS in 10gR2 and 11g? (Doc ID 788145.1)

Last updated on FEBRUARY 20, 2012

Applies to:

Oracle Spatial - Version: 10.2.0.1 to 11.1.0.7 - Release: 10.2 to 11.1
Information in this document applies to any platform.

Goal

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.

Solution

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