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

Last updated on NOVEMBER 17, 2016

Applies to:

Oracle Spatial and Graph - Version 10.2.0.1 to 11.2.0.4 [Release 10.2 to 11.2]
Information in this document applies to any platform.

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

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