thanks for that... I'm getting closer ....
se...@seanspc:~/gdal$ time ogr2ogr -f OCI
OCI:geoserver/geoser...@mfproduk_11g../shapes/Fluvial_Extents/FluvialUD04Q200Outline.shp
-lco srid=81989 -lco
PRECISION=NO -progress -lco DIM=2
0...10...20...30...40...50...60...70...80...90...100 - done.
ERROR 1: ORA-13223: duplicate entry for FLUVIALUD04Q200OUTLINE.ORA_GEOMETRY
in SDO_GEOM_METADATA
ORA-06512: at "MDSYS.MD", line 1723
ORA-06512: at "MDSYS.MDERR", line 17
ORA-06512: at "MDSYS.SDO_GEOM_TRIG_INS1", line 48
ORA-04088: error during execution of trigger 'MDSYS.SDO_GEOM_TRIG_INS1'
in INSERT INTO USER_SDO_GEOM_METADATA VALUES ('FLUVIALUD04Q200OUTLINE',
'ORA_GEOMETRY',
MDSYS.SDO_DIM_ARRAY(MDSYS.SDO_DIM_ELEMENT('X',138874.997,654690.003,0.001),MDSYS.SDO_DIM_ELEMENT('Y',15619.997,814145.0030999999,0.001)),
81989)
real 0m42.414s
user 0m19.900s
sys 0m0.440s
On Mon, Jul 26, 2010 at 1:11 PM, Rahkonen Jukka
<[email protected]>wrote:
> Hi,
>
> http://gdal.org/ogr/drv_oci.html says:
> Layer Creation Options
> DIM: This may be set to 2 or 3 to force the dimension of the created layer.
> If not set 3 is used by default.
>
> Have you tried that?
>
> -Jukka-
>
> Sebastian E. Ovide wrote:
>
>
> On Fri, Jul 23, 2010 at 7:38 PM, Jukka Rahkonen
> <[email protected]>wrote:
>
> > Validate geometries
>
> validating geometries it came out: ORA-54668: a 2D SRID cannot be used with
> a 3D geometry
>
> therefore I've used the option -nlt POINT as suggested
>
> http://osgeo-org.1803224.n2.nabble.com/howto-flattening-of-3D-shapefiles-td3038433.html
>
> but I still get the same ORA-54668 validation error...
>
> any ideas ?
>
>
> --
> Sebastian E. Ovide
>
>
--
Sebastian E. Ovide
_______________________________________________
gdal-dev mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/gdal-dev
