Hi folks
I am trying to find the Oracle SRID codes for EPSG codes 4893 and 4759, but am having no success yet. We are at version 10.2.0.4.0.
This query returns no records for me:
<pre>
select * from mdsys.cs_srs where wktext LIKE 'GEOGCS[""NAD83(NSRS2007)"", DATUM[""NAD83_National_Spatial_Reference_System_2007""%';
</pre>
Because we are not at version 11.2, I can’t use the function "find_geog_crs()" with WKT as the first argument – it only wants to accept an SRID, which is what I’m trying to find.
Can anyone help:
a) identify the correct Oracle SRIDs for these EPSG codes?
b) tell me the proper steps to take in order to add these missing CRS's to our database?
Any assistance would be much appreciated!