I've tried it again on a different server, this time with Oracle 10g... I'm getting the same error... <br><br>note: using the same server I'm not getting any error using shp2sdo (<a href="http://www.oracle.com/technology/software/products/spatial/files/shp2sdo_readme.html">http://www.oracle.com/technology/software/products/spatial/files/shp2sdo_readme.html</a>)<br>
<br><div class="gmail_quote">On Thu, Jul 22, 2010 at 3:36 PM, Sebastian E. Ovide <span dir="ltr"><<a href="mailto:sebastian.ovide@gmail.com">sebastian.ovide@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<br>Hi Ivan,<br><br>I've tried again without the ":"... and the problem is still there...<br><br>sebas@SeansPC:~/shapes/Fluvial_Extents$ time ogr2ogr -f OCI OCI:geoserver/geoserver@mfproduk_11g FluvialUD04Q75Outline.shp -lco srid=81989 -lco PRECISION=NO -progress<div class="im">
<br>
0...10...20...30...40...50...60...70...80...90...100 - done.<br>ERROR 1: ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine<br>ORA-13249: internal error in Spatial index: [mdidxrbd]<br>ORA-13249: Error in Spatial index: index build failed<br>
ORA-13249: Error in spatial index: [mdrcrtxfergm]<br>ORA-13249: Error in spatial index: [mdpridxtxfergm]<br></div>ORA-13200: internal error [ROWID:AAASMIAAFAABEt0AAD] in spatial indexing.<div class="im"><br>ORA-13206: internal error [] while creating the spatial index<br>
ORA-13034: Invalid data in the SDO_ORDINATE_ARRAY in SDO_GEOMETRY object<br>ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 10<br></div> in CREATE INDEX "OSI_15101" ON FLUVIALUD04Q75OUTLINE("ORA_GEOMETRY") INDEXTYPE IS MDSYS.SPATIAL_INDEX<br>
<br>real 1m25.698s<br>user 0m26.660s<br>sys 0m0.580s<br><br>regards<div><div></div><div class="h5"><br><br><div class="gmail_quote">On Thu, Jul 22, 2010 at 3:24 PM, Ivan Lucena <span dir="ltr"><<a href="mailto:ivan.lucena@pmldnet.com" target="_blank">ivan.lucena@pmldnet.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">Hi Sebastian,<br>
<br>
Did you intend to enter table name after "OCI:geoserver/geoserver@mfproduk_11g:"?<br>
<br>
I am asking that because there is a ":" at the end but with no information after that.<br>
<br>
I don't know if that would affect the OCI driver.<br>
<br>
Regards,<br>
<br>
Ivan<br>
<div><div></div><div><br>
<br>
> -------Original Message-------<br>
> From: Sebastian E. Ovide <<a href="mailto:sebastian.ovide@gmail.com" target="_blank">sebastian.ovide@gmail.com</a>><br>
> To: <a href="mailto:gdal-dev@lists.osgeo.org" target="_blank">gdal-dev@lists.osgeo.org</a><br>
> Subject: [gdal-dev] ogr2ogr OCI: problem loading shapes<br>
> Sent: Jul 22 '10 09:14<br>
><br>
> Hi All<br>
><br>
> sebas@SeansPC:~/shapes/Fluvial_Extents$ time ogr2ogr -f OCI<br>
> OCI:geoserver/geoserver@mfproduk_11g: FluvialUD04Q100Outline.shp -lco<br>
> srid=81989 -lco PRECISION=NO -progress<br>
> 0...10...20...30...40...50...60...70...80...90...100 - done.<br>
> ERROR 1: ORA-29855: error occurred in the execution of ODCIINDEXCREATE<br>
> routine<br>
> ORA-13249: internal error in Spatial index: [mdidxrbd]<br>
> ORA-13249: Error in Spatial index: index build failed<br>
> ORA-13249: Error in spatial index: [mdrcrtxfergm]<br>
> ORA-13249: Error in spatial index: [mdpridxtxfergm]<br>
> ORA-13200: internal error [ROWID:AAASLwAAFAAA5AxAAC] in spatial indexing.<br>
> ORA-13206: internal error [] while creating the spatial index<br>
> ORA-13034: Invalid data in the SDO_ORDINATE_ARRAY in SDO_GEOMETRY object<br>
> ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 10<br>
> in CREATE INDEX "OSI_16180" ON FLUVIALUD04Q100OUTLINE("ORA_GEOMETRY")<br>
> INDEXTYPE IS MDSYS.SPATIAL_INDEX<br>
><br>
> real 1m10.377s<br>
> user 0m27.680s<br>
> sys 0m0.710s<br>
> sebas@SeansPC:~/shapes/Fluvial_Extents$ ogrinfo FluvialUD04Q100Outline.shp<br>
> INFO: Open of `FluvialUD04Q100Outline.shp'<br>
> using driver `ESRI Shapefile' successful.<br>
> 1: FluvialUD04Q100Outline (Polygon)<br>
> sebas@SeansPC:~/shapes/Fluvial_Extents$<br>
><br>
> sebas@SeansPC:~/shapes/Fluvial_Extents$ ogrinfo --version<br>
> GDAL 1.7.2, released 2010/04/23<br>
><br>
><br>
> ideas ?<br>
><br>
> --<br>
> Sebastian E. Ovide<br>
><br>
><br>
</div></div>> --------------------<br>
> _______________________________________________<br>
> gdal-dev mailing list<br>
> [LINK: compose.php?to=<a href="mailto:gdal-dev@lists.osgeo.org" target="_blank">gdal-dev@lists.osgeo.org</a>] <a href="mailto:gdal-dev@lists.osgeo.org" target="_blank">gdal-dev@lists.osgeo.org</a><br>
> [LINK: <a href="http://lists.osgeo.org/mailman/listinfo/gdal-dev" target="_blank">http://lists.osgeo.org/mailman/listinfo/gdal-dev</a>]<br>
<div><div></div><div>> <a href="http://lists.osgeo.org/mailman/listinfo/gdal-dev" target="_blank">http://lists.osgeo.org/mailman/listinfo/gdal-dev</a><br>
</div></div></blockquote></div><br><br clear="all"><br></div></div>-- <br><font color="#888888">Sebastian E. Ovide<br><br><br><br><br>
</font></blockquote></div><br><br clear="all"><br>-- <br>Sebastian E. Ovide<br><br><br><br>