[gdal-dev] ogr2ogr OCI: problem loading shapes

[Sebastian E. Ovide]

I've tried it again on a different server, this time with Oracle 10g... I'm
getting the same error...

note: using the same server I'm not getting any error using shp2sdo (
http://www.oracle.com/technology/software/products/spatial/files/shp2sdo_readme.html
)

On Thu, Jul 22, 2010 at 3:36 PM, Sebastian E. Ovide <
sebastian.ovide at gmail.com> wrote:

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


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