How To Add A New Coordinate System based on the EPSG model introduced in 10gR2 (Doc ID 371935.1)

Last updated on MARCH 28, 2019

Applies to:

Goal

Creating a user-defined coordinate system was done by adding a new row to the MDSYS.CS_SRS table before the 10.2 release. As of 10.2 coordinate system support is based upon the EPSG(European Petroleum Survey Group) model which is implemented using a different table structure.

For more information about this new implementation: 
     Spatial User's Guide and Reference 11g Release 2.

This note provides an sample script to create a user-defined coordinate system based upon this new EPSG model.

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.