SDO_GEOMETRY size limits here to stay?
Hi folks,
Recently I seem to be receiving more and more polygons from various ESRI-type folks that are too large to store in an Oracle SDO_ORDINATE_ARRAY. I was just reading the 11g docs at http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28400/sdo_objrelschema.htm#i1004087
and nothing has changed in this regard - I quote "Because the maximum SDO_ORDINATE_ARRAY size is 1,048,576 numbers, the maximum number of vertices in an SDO_GEOMETRY object depends on the number of dimensions per vertex: 524,288 for two dimensions, 349,525 for three dimensions, and 262,144 for four dimensions."
Does anyone have any thoughts on the matter or heard rumors of a fix or an approach to the issue (some kind of way of braking these big guys up?). I'd say generally I am receiving a few exceptional polygons upwards of 500,000 to a million vertices. Not much more than that but enough to muff oracle. Is the official Oracle response to the matter to ask what on earth anyone would want with a 500,000 vertice polygon? I too wish these things were not coming my way but they are. Thanks for any input.
Cheers,
Paul