Hi everyone
<div><br></div><div>When importing an ED50 (EPSG:4230) shapefile to Oracle Spatial 11g2, </div><div><br></div><div>ogr2ogr -a_srs EPSG:4230 -f OCI blabla</div><div><br></div><div>a get an insufficient privileges error . however when specifying EPSG:4326 it works. Which is ironic, since the actual data _is_ 4230. </div>
<div><br></div><div>SRID=4230 is , after all , present in the SDO_COORD_REF_SYS table as well as the GDAL_DATA files.</div><div><br></div><div>Here is the WKT as reported by OGR : </div><div><br></div><div>GEOGCS["GCS_European_1950",<p>
</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"> DATUM["European_Datum_1950",</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"> SPHEROID["International_1924",6378388.0,297.0]],</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"> PRIMEM["Greenwich",0.0],</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"> UNIT["Degree",0.0174532925199433]]</p><p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">
<br></p><p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><br></p><p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">
This is easy to reproduce, simply download for example the "fields" dataset from the NPD : </p><p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">
<br></p><p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><a href="http://www.npd.no/engelsk/cwi/pbl/en/factmap/download/shapes_welcome.htm">http://www.npd.no/engelsk/cwi/pbl/en/factmap/download/shapes_welcome.htm</a></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><br></p><p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">
<br></p><p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><br></p><p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">
Cheers, </p><p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">Anders</p></div>