[gdal-dev] Re: ogr/oci import : a_srs EPSG:4230 fails

[Jukka Rahkonen]

Anders Moe <anders.moe <at> geocap.no> writes:

> 
> 
> Hi everyone
> 
> 
> When importing an  ED50 (EPSG:4230) shapefile to Oracle Spatial 11g2, 
> 
> ogr2ogr -a_srs EPSG:4230 -f OCI blabla
> 
> a get an insufficient privileges error


I would have a try with -lco SRID=4230.  Ogr2ogr tries to find exact match and
if that fails it tries to insert new projection definitions.
Excerpt from http://gdal.org/ogr/drv_oci.html
"SRID: By default this driver will attempt to find an existing row in the
MDSYS.CS_SRS table with a well known text coordinate system exactly matching the
one for this dataset. If one is not found, a new row will be added to this
table. The SRID creation option allows the user to force use of an existing
Oracle SRID item even it if does not exactly match the WKT the driver expects."

-Jukka Rahkonen-