MDSYS.SDO_COORD_OPS Table Does Not Contain Data For SRID 3078 (Doc ID 1571409.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial - Version 11.2.0.3 and later
Information in this document applies to any platform.

Goal

SRID 3078 is missing

The database was on 10g and the SRID was present, the database was upgraded to 11g and the SRID was present. Somehow the SRID is not present now.
The cause of this is unknown

How to restore the SRID 3078?
 

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