Re: Oracle Spatial: huge mdsys.sdo_geometry

Jep,

thats what I read in the Documatation.

Howevere, I only had a mere 210 000 coodrdiantes (ie 105 000 2d points). And, the problem already occured with just above 128 000 coordinates. And that made it suspecious to me as that would be 2^16 2D points which I am now afraid could be a limit.
The porb is not to build the geometry, but as soon as I get it into a sdo_geometry type variable and trying to query it, I am running into problems.
The same is, with a RELATE in an SELECT statement. It simply wouldnt ever finish.

But by now, we figured out that, in our case, polygons with more than 2^16 nodes are useless as the GIS we are using cant handle them anyway...

Christof

Hans Leirvik wrote:

> How many points do you have in your polygon.
> I think the SDO_ORDINATE array is a VARRAY which has a maximim of 1000000
> numbers.
> This gives you a maximum of 500000 points in your polygons if you have 2D
> points
> and 333333 if you have 3D points in your polygon.
>
> Hans
>
> "Christof Kaiser" <kaiser_at_logiball.deREMOVETHIS> wrote in message
> news:3B1E42F2.114A9D14_at_logiball.deREMOVETHIS...
> > Hi,
> >
> > using Orcale 8i (Spatial) to store polygons I got a problem when these
> > are getting fairly big (in terms of the SDO_ORDINATES array).
> > I can build the polygon, but when retrieving it I get a
> > ORA-22813: operand value exceeds system limits.
> >
> > Also, trying to SDO_RELATE it with another polygon, the SELECT (where
> > the relate is in) never comes back.
> > An exception would be fair, but not giving back the control flow (for
> > hours) is indeed nasty.
> >
> > Any comments appreciated.
> >
> > Regards
> >
> > Christof
> >
Received on Thu Jun 07 2001 - 08:50:58 CDT