add a custom projected coordinate system
How do I add a new projected coordinate system in 11g? This is how I did it in 10g.
insert into cs_srs (cs_name, srid, auth_srid, auth_name, wktext) values
('Mercator37', 49155000, 49155000, 'EDR',
'PROJCS["Mercator",
GEOGCS [
"NAD 83 (Continental US)",
DATUM [
"NAD 83 (Continental US)",
SPHEROID ["GRS 80", 6378137, 298.257222101]],
PRIMEM [ "Greenwich", 0.000000 ],
UNIT ["Decimal Degree", 0.01745329251994330]],
PROJECTION ["Mercator"],
PARAMETER ["Latitude_Of_Origin", 37.000000],
PARAMETER ["False_Easting", 0.000000],
PARAMETER ["False_Northing", 0.000000],
UNIT["U.S. Foot",0.3048006096012192]]');
0