[gdal-dev] ogr2ogr OCI: ORA-13349 and ORA-13356

[Sebastian E. Ovide]

yes, updating the metadata worked.

Is there anyway to do it through ogr2ogr ?

We are trying to replace shp2do with ogr2ogr as shp2do requires multiple
steps (create do, import it and then create the index by hand)... and for
what I've seen with PostGIS, ogr2ogr is a single line operation.... How can
be done in Oracle ?(single line without modifying shapes)


thanks

On Mon, Oct 11, 2010 at 11:29 AM, Michael Shishcu <micklesh at gmail.com>wrote:

> I mean, you have points in your shape(s) too close to each other.
> When you are importing them, oracle "interprets" them as the same point
> (ORA-13356) or overlapping ones (ORA-13349).
> ways to escape
> - "simplify" your shapes - delete adjacent points (too close ones)
> - change your metadata for the layer (insert or update)
>
> insert into USER_SDO_GEOM_METADATA
> values ('LAYER','COLUMN',
> mdsys.sdo_dim_array(
> mdsys.sdo_dim_element('X',minX,maxX, toleranceX),
> mdsys.sdo_dim_element('Y',minY,maxY, toleranceY)
> ),
> SRID), so that toleranceX and toleranceY are small enough to serve your
> shapes
>
> regards, michael
>



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