[gdal-dev] ogr2ogr OCI: problem loading shapes

[Sebastian E. Ovide]

Hi Ivan,

I've tried again without the ":"... and the problem is still there...

sebas at SeansPC:~/shapes/Fluvial_Extents$ time ogr2ogr -f OCI
OCI:geoserver/geoserver at mfproduk_11g FluvialUD04Q75Outline.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:AAASMIAAFAABEt0AAD] 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_15101" ON FLUVIALUD04Q75OUTLINE("ORA_GEOMETRY")
INDEXTYPE IS MDSYS.SPATIAL_INDEX

real    1m25.698s
user    0m26.660s
sys     0m0.580s

regards

On Thu, Jul 22, 2010 at 3:24 PM, Ivan Lucena <ivan.lucena at pmldnet.com>wrote:

> 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
>



-- 
Sebastian E. Ovide
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/gdal-dev/attachments/20100722/fb470e67/attachment.html