so with shp2sdo there is one row that is not loaded into the table:<br><br>Record 28832: Rejected - Error on table SEBAS, column GEOM.SDO_ORDINATES.<br>element count is greater than maximum allowed for the column<br><br>Table SEBAS:<br>
28891 Rows successfully loaded.<br> 1 Row not loaded due to data errors.<br> 0 Rows not loaded because all WHEN clauses were failed.<br> 0 Rows not loaded because all fields were null.<br><br>shp2sdo also generates a file with that bad record:<br>
<br>-rw-r--r-- 1 sebas sebas 17934244 2010-07-27 09:19 sebas.bad<br><br>that record 28832 is loaded into the table using ogr2ogr<br><br>that record has the validation error 13034 : Invalid data in the SDO_ORDINATE_ARRAY in SDO_GEOMETRY object<br>
<br>If I delete that record (as shp2sdo does by the way) then I can create the index...<br><br><br><br><div class="gmail_quote">On Mon, Jul 26, 2010 at 6:08 PM, Jukka Rahkonen <span dir="ltr"><<a href="mailto:jukka.rahkonen@mmmtike.fi">jukka.rahkonen@mmmtike.fi</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;"><div class="im">Sebastian E. Ovide <sebastian.ovide <at> <a href="http://gmail.com" target="_blank">gmail.com</a>> writes:<br>
<br>
><br>
><br>
> You are right...aften done it, still getting the oringinal error due to errors<br>
in the geometries...now, If I import the same data using shp2sdo, I do NOT get<br>
any error creating the index... the shape get imported and the index is<br>
created... even if there are errors in the geometries...any ideas ?I know that I<br>
could use shp2sdo as it is working... but it requires extra work (something like<br>
5 command lines)... and as I'm using gdal for importing rasters, I'd like to use<br>
it also for shapes...thanks again<br>
<br>
</div>There must be an error in some geometry imported into Oracle with ogr2ogr. The<br>
same geometry is OK when imported with shp2sdo. I think that the only reasonable<br>
thing to do is to find that geometry, see how it looks like in the original data<br>
and when imported with shp2sdo. I believe it can also be imported till Oracle<br>
with ogr2ogr by using option -lco INDEX=OFF. In that case there should be enough<br>
information to find the reason for your issue.<br>
<br>
_______________________________________________<br>
gdal-dev mailing list<br>
<div class="im"><a href="mailto:gdal-dev@lists.osgeo.org">gdal-dev@lists.osgeo.org</a><br>
</div><div><div></div><div class="h5"><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>-- <br>Sebastian E. Ovide<br><br><br><br><br>