[gdal-dev] Shapefile to Oracle Spatial with OGR2OGR - Unique constraint on ID field

[massimiliano]

Hi
I'm trying to load a test shapefile into Oracle using this syntax:

ogr2ogr -f "OCI" OCI:user/pwd at service test.shp -lco dim=2 -lco srid=3003
-nln test

Shapefile contains a non-nullable FID field, which I wish to be used as
unique constraint on the oracle table being created.
However, this unique constraint is not created on Oracle, resulting in the
OGR_FID column being nullable and not unique.
Is this a known behaviour? Of course I could write a simple SQL script as a
workaround, but one would think OGR2OGR should do this automatically.
Thanks.



--
View this message in context: http://osgeo-org.1560.x6.nabble.com/Shapefile-to-Oracle-Spatial-with-OGR2OGR-Unique-constraint-on-ID-field-tp5221365.html
Sent from the GDAL - Dev mailing list archive at Nabble.com.