Re: [gdal-dev] ogr2ogr OCI: problem loading shapes

[Ivan Lucena]

Hi Sebastian,

Did you intend to enter table name after "OCI:geoserver/geoserver at mfproduk_11g:"?

I am asking that because there is a ":" at the end but with no information after that. 

I don't know if that would affect the OCI driver.

Regards,

Ivan


>  -------Original Message-------
>  From: Sebastian E. Ovide <sebastian.ovide at gmail.com>
>  To: gdal-dev at lists.osgeo.org
>  Subject: [gdal-dev] ogr2ogr OCI: problem loading shapes
>  Sent: Jul 22 '10 09:14
>  
>  Hi All
>  
>  sebas at SeansPC:~/shapes/Fluvial_Extents$ time ogr2ogr -f OCI
>  OCI:geoserver/geoserver at mfproduk_11g: FluvialUD04Q100Outline.shp -lco
>  srid=81989 -lco PRECISION=NO -progress
>  0...10...20...30...40...50...60...70...80...90...100 - done.
>  ERROR 1: ORA-29855: error occurred in the execution of ODCIINDEXCREATE
>  routine
>  ORA-13249: internal error in Spatial index: [mdidxrbd]
>  ORA-13249: Error in Spatial index: index build failed
>  ORA-13249: Error in spatial index: [mdrcrtxfergm]
>  ORA-13249: Error in spatial index: [mdpridxtxfergm]
>  ORA-13200: internal error [ROWID:AAASLwAAFAAA5AxAAC] in spatial indexing.
>  ORA-13206: internal error [] while creating the spatial index
>  ORA-13034: Invalid data in the SDO_ORDINATE_ARRAY in SDO_GEOMETRY object
>  ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 10
>   in CREATE INDEX "OSI_16180" ON FLUVIALUD04Q100OUTLINE("ORA_GEOMETRY")
>  INDEXTYPE IS MDSYS.SPATIAL_INDEX
>  
>  real    1m10.377s
>  user    0m27.680s
>  sys     0m0.710s
>  sebas at SeansPC:~/shapes/Fluvial_Extents$ ogrinfo FluvialUD04Q100Outline.shp
>  INFO: Open of `FluvialUD04Q100Outline.shp'
>        using driver `ESRI Shapefile' successful.
>  1: FluvialUD04Q100Outline (Polygon)
>  sebas at SeansPC:~/shapes/Fluvial_Extents$
>  
>  sebas at SeansPC:~/shapes/Fluvial_Extents$ ogrinfo --version
>  GDAL 1.7.2, released 2010/04/23
>  
>  
>  ideas ?
>  
>  --
>  Sebastian E. Ovide
>  
>  
>  --------------------
>  _______________________________________________
>  gdal-dev mailing list
>  [LINK: compose.php?to=gdal-dev at lists.osgeo.org] gdal-dev at lists.osgeo.org
>  [LINK: http://lists.osgeo.org/mailman/listinfo/gdal-dev]
>  http://lists.osgeo.org/mailman/listinfo/gdal-dev